tommywenjiezhang / Database-Project

0 stars 5 forks source link

question 13 #9

Closed tommywenjiezhang closed 3 years ago

tommywenjiezhang commented 3 years ago

You remember from your statistics classes that to get a smoother distribution of the temperatures and eliminate the small daily changes that you should use a moving average instead of the actual temperatures. Using the windowing within a ranking function to create a 4 day moving average, calculate the moving average for each day of the year.