TrainityTrainity
All ideas

Jobs Reviewed Over Time: Objective: Calculate the number of jobs reviewed per hour for each day in November 2020. Your Task: Write an SQL query to calculate the number of jobs reviewed per hour for each day in November 2020.

SELECT ds AS date, EXTRACT(DAY FROM CAST(ds AS DATE)) AS day, COUNT(*) AS job_count, COUNT(*) / 24.0 AS jobreviewedper_hr FROM job_data WHERE ds LIKE '2020/11/%' GROUP BY date, day ORDER BY date; is this syntax correct or can you please provide me guidance in this task, i am a bit confused in this task, i am stuck here