LeetCode[MySQL] : Rising Temperature

Rising Temperature

Q

SELECT W2.id
FROM Weather W1 LEFT OUTER JOIN Weather W2
ON W1.recordDate =  SUBDATE(W2.recordDate,1) # W2.recordDate-1 틀림
WHERE W2.temperature > W1.temperature