79291962

Date: 2024-12-18 17:22:01
Score: 1
Natty:
Report link
SELECT w1.id
FROM Weather AS w1
JOIN Weather AS w2
    ON w1.recordDate = DATE_ADD(w2.recordDate, INTERVAL 1 DAY)
WHERE w1.temperature > w2.temperature;

Just use of DATE_ADD(parameter2, INTERVAL DAY)

Reasons:
  • Low length (0.5):
  • Has code block (-0.5):
  • Low reputation (1):
Posted by: Abhiraj Adhikary