Shorter post and easier problem today as I'm on my first day of a one-week long vacation.
DATEDIFF Function: https://lnkd.in/dqgnGN7
Today's coding challenge comes from #leetcode(https://lnkd.in/dEJgFhN): Write a SQL query to find all dates' id with higher temperature compared to its previous dates (yesterday). Return the result table in any order.
![](https://static.wixstatic.com/media/2d9ab2_f053285413bd458b8f5d25a840d954cc~mv2.jpeg/v1/fill/w_800,h_219,al_c,q_80,enc_auto/2d9ab2_f053285413bd458b8f5d25a840d954cc~mv2.jpeg)
Comments