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.
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 monthly temperature swing per location and month
SELECT
state,
year_month,
___ AS monthly_swing
FROM ___
___
ORDER BY state, year_month;