TrainityTrainity
All ideas

project 3 case study 1

WITH jobsreviewper_hr AS (SELECT ds AS "review date", Round (Count(jobid) / Sum(timespent) * 3600) AS "reviewperhr" FROM job_data WHERE Month (ds) = 11 GROUP BY ds) SELECT Round(Sum(reviewperhr) / 30) AS "jobs reviewed per hr per day" FROM jobsreviewper_hr; is this correct for the 1st task