Get startedGet started for free

Ranking cold weather

You are working for the national weather agency for the US. Texas has been experiencing some unusually cold weather later and you have been tasked to analyze historical data and rank the coldest temperatures.

Rank the TX weather station data by t_monthly_min. Rank 1 should appear first and have the lowest temperature. Temperatures that are the same should have the same rank.

You will need to join temperatures_monthly and temperature_stations.

This exercise is part of the course

Time Series Analysis in PostgreSQL

View Course

Exercise instructions

  • Rank t_monthly_min for the TX weather station by joining the two tables and partitioning by station_id; rank 1 should have the lowest temperature.

Hands-on interactive exercise

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

-- Rank the lowest temperatures in Texas
SELECT
	ts.state,
	year_month,
	t_monthly_min,
    ___ (
		___
		___) AS rank
FROM temperatures_monthly AS tm
___ AS ts 
	USING(___)
___
ORDER BY rank;
Edit and Run Code