[SQL50] 197. Rising Temperature (JOIN)SELECT A.idFROM Weather A LEFT JOIN (SELECT id, LAG(recordDate, 1) OVER(ORDER BY recordDate) AS yesterday, LAG(temperature, 1) OVER(ORDER BY recordDate) AS prev_temp FROM Weather) B ON A.id = B.idWHERE temperature > B.prev_temp AND B.yesterday = recordDate - 1;LAG이전 행의 값을 가져올 수 있다. SELECT t, val, LAG(val) AS 'lag'FROM seriesO..
