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:
min_spread: maximum minimum monthly temperature - the minimum minimum monthly temperaturemax_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.
Deze oefening maakt deel uit van de cursus
Time Series Analysis in PostgreSQL
Praktische interactieve oefening
Probeer deze oefening eens door deze voorbeeldcode in te vullen.
-- Calculate the overall min_spread and max_spread
SELECT
___ AS min_spread,
___ AS max_spread
FROM ___;