simple solution


  • 1
    3
    select b.Id 
    from Weather a
    INNER JOIN Weather b on DATE_ADD(a.Date,INTERVAL 1 DAY)=b.Date
    where b.Temperature>a.Temperature
    

Log in to reply
 

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