leetcode

Leetcode submissions
git clone git://git.laack.co/leetcode.git
Log | Files | Refs | README

rising-temp.sql (164B)


      1 --Runtime 589ms Beats 97.92%
      2 
      3 
      4 SELECT W.id Id
      5 FROM Weather W
      6 LEFT JOIN Weather W1
      7 ON SUBDATE(W1.recordDate, -1) = W.recordDate
      8 WHERE W1.temperature < W.temperature