TrainityTrainity
All ideas

Operation Analytics DataSet Error

The current dataset doesn't even seem possible to work with. I can't even imagine doing these (Jobs Reviewed Over Time: Objective: Calculate the number of jobs reviewed per hour for each day in November 2020. Your Task: Write an SQL query to calculate the number of jobs reviewed per hour for each day in November 2020.) (Throughput Analysis: Objective: Calculate the 7-day rolling average of throughput (number of events per second). Your Task: Write an SQL query to calculate the 7-day rolling average of throughput. Additionally, explain whether you prefer using the daily metric or the 7-day rolling average for throughput, and why.) The data contain various unique actor entries. How am I supposed to provide job reviews per hour? It doesn't even make sense. Please kindly assit.