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

Exercise

Calculating monthly temperature swings

You are a data scientist on a weather project. You've previously analyzed how minimum and maximum monthly temperatures can vary over time and by location.

Now you are interested in the monthly temperature swing. This is given by the formula:

monthly maximum temperature - monthly minimum temperature.

temperature_stations and temperatures_monthly are available to you.

Instructions 1/3

undefined XP
    1
    2
    3
  • Calculate the monthly temperature swing per location and for each month.