Get startedGet started for free

Aggregating temperature data

As a data scientist on a research project studying climate cycles you are analyzing how much the monthly high and low temperatures vary over time.

You are interested in the difference between the maximum-minimum monthly temperature and the minimum-minimum monthly temperature, and in the metric for the monthly max temperatures. You call these min_spread and max_spread respectively:

  1. min_spread : maximum minimum monthly temperature - the minimum minimum monthly temperature
  2. max_spread : maximum maximum monthly temperature - the minimum maximum monthly temperature

You will first aggregate these two metrics on an overall basis. Then, you will aggregate by location and look at the variation by season.

temperature_stations and temperatures_monthly are available to you.

This exercise is part of the course

Time Series Analysis in PostgreSQL

View Course

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

-- Calculate the overall min_spread and max_spread
SELECT
    ___ AS min_spread,
    ___ AS max_spread
FROM ___;
Edit and Run Code