CASE STUDY 1

TASK ONE IS THE BELOW QUIREY RIGHT SELECT DATE(ds) AS review_date, HOUR(ds) AS review_hour, COUNT(*) AS jobsreviewedper_hour FROM EventData WHERE MONTH(ds) = 11 AND YEAR(ds) = 2020 GROUP BY reviewdate, reviewhour ORDER BY reviewdate, reviewhour;