Project 3 Case study 1 - Task 2

Hi, Could you please help me with understanding this task. 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. Doubt - What is throughput? if it number of events occured per second as mentioned in the task above - then do we need to calculate (number of events / total time spent on this event) or (number of events / total secs in a day)? For example - if we have 3 events occured on a particular date and it took around 5592 secs to complete. then throughput per day should be (3/5592) secs or (3/86400) secs? Kindly help with this query