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
Exercise instructions
- Rank the
t_monthly_max
for the state ofCA
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;