TrainityTrainity
All ideas

Project -3 (Operation Analytics and Investigating Metric Spike Advanced SQL)

In the Project -3 (Operation Analytics and Investigating Metric Spike Advanced SQL) I am facing difficulty in understanding the questions and tasks asked Tasks: 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. What does (number of events per second) means ?! How to calculate the 7-day rolling average with the data containing entries of only 5 distinct dates ?