#197 Rising Temperature

https://leetcode.com/problems/rising-temperature

MS SQL Server

SELECT W2.id
FROM Weather W1, Weather W2
WHERE DATEDIFF(DAY, W1.recordDate, W2.recordDate) = 1
AND W2.temperature > W1.temperature;