project 3 case b

can you please help me with throughput analysis. Like how I am supposed to calculate 7 days rolling average when the data is only available for 6 days. and also do I have to write 2 different query 1 for weekly analysis and another for daily metric?