1. Learn
    2. /
  2. Courses
    3. /
  3. Time Series Analysis in PostgreSQL
Connected

Exercise

Single running average

As a researcher at the national weather agency, you want to run more analysis on the latest temperature data and you've just learned how to do running averages. You're keen to gain new insights and show them to the rest of the team.

Your task is to calculate the running average of the lowest monthly temperatures in Hawaii in the available dataset.

Instructions

100 XP
  • Use a window function to calculate the running average for t_monthly_min for a single weather station in Hawaii, HI.