All ideas
project 3 case 1
WITH jobsreviewper_hr AS (SELECT ds AS "review date", Round (Count(jobid) / Sum(timespent) * 3600) AS "reviewperhr" FROM job_data WHERE ds between '11/24/2020' and '11/30/2020' GROUP BY ds) SELECT Round(Sum(reviewperhr) / 30) AS "jobs reviewed per hr per day" FROM jobsreviewper_hr; i am getting 25 is it correct please help me! it a request
