Rising Temperature https://leetcode.com/problems/Rising-Temperature/ SELECT today.id FROM weather AS today INNER JOIN weather AS yesterday ON DATE_ADD(yesterday.recordDate, INTERVAL 1 DAY) = today.recordDate WHERE today.temperature > yesterday.temperature # # {"headers": ["id", "recordDate", "temperature", "id", "recordDate", "temperature"], # # "values": # # [[2, "2015-01-02", 25, 1, "2015-01-0..