My simple solution using date_sub


  • 0
    Q

    My simple solution:

    SELECT w1.Id
    FROM Weather w1
    WHERE w1.Temperature > (SELECT Temperature
    FROM Weather
    WHERE Date = date_sub(w1.Date, interval 1 day));


Log in to reply
 

Looks like your connection to LeetCode Discuss was lost, please wait while we try to reconnect.