SQL-Leetcode/0197-RisingTemperature.sql at main · ninad-moree/SQL-Leetcode · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
/*
    Write a solution to find all dates' Id with higher temperatures compared to its previous dates (yesterday). Return the result table in any order.

    Example 1:

    Input:
    Weather table:
    +----+------------+-------------+
    | id | recordDate | temperature |
    +----+------------+-------------+
    | 1  | 2015-01-01 | 10          |
    | 2  | 2015-01-02 | 25          |
    | 3  | 2015-01-03 | 20          |
    | 4  | 2015-01-04 | 30          |
    +----+------------+-------------+
    Output:
    +----+
    | id |
    +----+
    | 2  |
    | 4  |
    +----+
    Explanation:
    In 2015-01-02, the temperature was higher than the previous day (10 -> 25).
    In 2015-01-04, the temperature was higher than the previous day (20 -> 30).
*/

SELECT w1.id
FROM Weather w1, Weather w2
WHERE datediff(w1.recordDate, w2.recordDate) = 1
AND w1.temperature > w2.temperature