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

Exercise

Partition by

You have been given monthly temperature data for various weather stations and are conducting an analysis on the minimum temperatures across the stations.

You're interested in grouping the data by the station_id and comparing the monthly minimum temperature with the minimum overall temperature of that station for the year 2010.

Instructions

100 XP
  • Use a window function to find the minimum t_monthly_min that is grouped by station_id, filtered for the year 2010.