04_rankingFunctions.sql

-- Ranking functions
SELECT *,
	RANK() 
		OVER(
		PARTITION BY t1.Area, t1.Property_type
		ORDER BY t1.Value DESC
		) rankValue,
	ROW_NUMBER() 
		OVER(
		PARTITION BY t1.Area, t1.Property_type
		ORDER BY t1.Date
		) rowNumber
FROM Medium.dbo.HPM09_202112 AS t1
WHERE t1.Value > 0  
	AND t1.Date BETWEEN '2020-01-01' AND '2020-06-01'
ORDER BY t1.Area, t1.Property_type, t1.Date