Rising Temprature
Rising Temprature

Given a Weather table, write a SQL query to find all dates’ Ids with higher temperature compared to its previous (yesterday’s) dates.

For example, return the following Ids for the above Weather table:


solution: 
Approach 1:

Approach 2:

Optimized Approach 3: