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

Exercise

Multi running average

The team leader was very impressed with your work getting the running average for Hawaii. They have now decided they need the running average of lowest monthly temperatures across all stations. Luckily, you know how to do to this quickly.

Instructions

100 XP
  • Use a window function to find the running average for t_monthly_min across various time series.