Get startedGet started for free

Multi running average

The team leader was very impressed with your work getting the running average for Hawaii. They have now decided they need the running average of lowest monthly temperatures across all stations. Luckily, you know how to do to this quickly.

This exercise is part of the course

Time Series Analysis in PostgreSQL

View Course

Exercise instructions

  • Use a window function to find the running average for t_monthly_min across various time series.

Hands-on interactive exercise

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

-- Calculate the running average of the lowest temperates for all stations
SELECT
	ts.state,
	year_month,
	t_monthly_min,
    ___ AS running_avg_temp
FROM temperatures_monthly AS tm
JOIN temperature_stations AS ts 
	USING(station_id)
ORDER BY ts.state, year_month;
Edit and Run Code