Ranking hot weather
You are working on a global climate report and need to determine the hottest temperatures for various weather stations. Hawaii is next on your list to analyze and rank the hottest months on record.
Rank the HI weather station data by t_monthly_max. Rank 1 should appear first and have the highest temperature. Temperatures that are the same should have the same rank, but no ranking levels should be skipped.
You will need to join temperatures_monthly and temperature_stations.
이 연습은 강의의 일부입니다
Time Series Analysis in PostgreSQL
연습 안내
- Rank
t_monthly_maxfor theHIweather station by joining the two tables; rank1should have the highest temperature.
실습형 인터랙티브 연습
이 예제를 이 샘플 코드를 완성하여 풀어보세요.
-- Rank the highest temperatures in Hawaii
SELECT
ts.state,
year_month,
t_monthly_max,
___ OVER (___) AS rank
___ AS tm
___ AS ts
USING(station_id)
___
ORDER BY rank;