[leetcode] [SQL] Rising Temperature

문제 설명

문제 풀이

SELECT
FROM Weather AS today
	INNER JOIN Weather AS yesterday
    ON DATE_ADD(yesterday.recordDate, INTERVAL 1 DAY) = today.recordDate
WHERE today.temperature > yesterday.temperature

실행 결과