TrainityTrainity
All ideas

Project 3 Case1 Query 1

Based on the question, (Write an SQL query to calculate the number of jobs reviewed per hour for each day in November 2020). Is that correct? Hence, would like to know if the below query is correct. (am attaching a screenshot of the result) SELECT CAST(ds AS DATE) AS Job_Date, COUNT(jobid) AS JobsPer_Day, SUM(timespent)/3600 AS TotalTimeSpentin_seconds, ROUND((3600 * COUNT(jobid)) / SUM(TimeSpent)/3600) AS JobsReviewedHour_Day FROM job_data WHERE CAST(ds AS DATE) >= '2020/11/01' AND CAST(ds AS DATE) <= '2020/11/30' GROUP BY Job_Date ORDER BY Job_Date;