Answered You can hire a professional tutor to get the answer.
Using the windowing within a ranking function to create 4 day moving average, calculate the moving average for each day of the year.
Using the windowing within a ranking function to create 4 day moving average, calculate the moving average for each day of the year.
City_Name Day of the Year Rolling_Avg_Temp
Mission 1 59.022719
Mission 2 58.524868
Mission 3 58.812967
Mission 364 60.657749
Mission 365 61.726333
Mission 366 61.972514
