regarding not getting output of table 1 - ques C

the code is used was SELECT language, COUNT(*) AS total_jobs, (COUNT() 100.0) / sum(COUNT(*)) OVER () AS percentage_share FROM job_data WHERE ds >= dateformat(dateadd(current_date, INTERVAL -30 DAY), 'yyyy/MM/dd') GROUP BY language; I also attached screenshot of the output that I am getting. Can you please give me some hint on how to run this query