Temperature percentile

-- 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;