Query in Project 3 Case Study 1

Based on the question, (Write an SQL query to calculate the number of jobs reviewed per hour for each day in November 2020), I am assuming that day means date and not Sunday/Monday etc. 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) AS TotalTimeSpentin_seconds, ROUND((3600 * COUNT(jobid)) / SUM(TimeSpent)) 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;