For example, return the following Ids for the above Weather table:
1 2 3 4 5 6
+----+ | Id | +----+ | 2 | | 4 | +----+
Solution
1 2 3 4 5 6 7 8
# Write your MySQL query statement below SELECT W1.Id FROM Weather W1, Weather W2 WHERE W1.Temperature > W2.Temperature AND TO_DAYS(W1.Date) - TO_DAYS(W2.Date) = 1