Get startedGet started for free

Temperature percentile

You are working for a national weather agency and have been tasked to create a report that indicates what percentile a month falls in based on its hottest temperatures. Knowing the percentile will help rank the hottest months.

You will be looking at weather data from California, CA.

This exercise is part of the course

Time Series Analysis in PostgreSQL

View Course

Exercise instructions

  • Rank the t_monthly_max for the state of CA and have this ranking be a percentile.

Hands-on interactive exercise

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

-- Rank the hottest months with a percentile
SELECT
	ts.state,
	year_month,
	t_monthly_max,
    ___ OVER (ORDER BY t_monthly_max DESC) AS percent_rank
FROM temperatures_monthly AS tm
JOIN temperature_stations AS ts 
	USING(station_id)
WHERE state = 'CA'
ORDER BY percent_rank;
Edit and Run Code