[ Web Proxy ]
URL:
Viewing: https://raw.githubusercontent.com/sirkalcode/LeetCode-Solutions/master/MySQL/rising-temperature.sql [Back]  [Original] 
# Time:  O(n^2)
# Space: O(n)

SELECT wt1.Id 
FROM Weather wt1, Weather wt2
WHERE wt1.Temperature > wt2.Temperature AND 
      TO_DAYS(wt1.DATE)-TO_DAYS(wt2.DATE)=1;
Web Proxy Viewer  |  New URL  |  Original Page