85. Rising Temperature
SELECT w1.id
FROM Weather w1
JOIN Weather w2
ON w1.recordDate = DATE_ADD(w2.recordDate, INTERVAL 1 DAY)
WHERE w1.temperature > w2.temperature;
'AI 부트캠프 > SQL 코드카타' 카테고리의 다른 글
| 72, 73 (0) | 2024.11.05 |
|---|---|
| 67, 68, 69, 70, 71 (0) | 2024.10.31 |
| 66 (0) | 2024.10.30 |
| 65 (0) | 2024.10.29 |
| 60, 61, 62, 63, 64 (2) | 2024.10.24 |