SQL Schema:

Create table Weather $($id int, recordDate date, temperature int$)$

Truncate table Weather

insert into Weather $($id$,$ recordDate, temperature$)$ values $(\text{'}1\text{'},\text{'}2015-01-01\text{'},\text{'}10\text{'})$

insert into Weather $($id$,$ recordDate, temperature$)$ values $(\text{'}2\text{'},\text{'}2015-01-02\text{'},\text{'}25\text{'})$

insert into Weather $($id$,$ recordDate, temperature$)$ values $(\text{'}3\text{'},\text{'}2015-01-03\text{'},\text{'}20\text{'})$

insert into Weather $($id$,$ recordDate, temperature$)$ values $(\text{'}4\text{'},\text{'}2015-01-04\text{'},\text{'}30\text{'})$

Table: Weather

$+---------------+---------+$

$|$ Column Name $|$ Type $|$

$+---------------+---------+$

$|$ id $|$ int $|$

$|$ recordDate $|$ date $|$

$|$ temperature $|$ int $|$

$+---------------+---------+$

id is the column with unique values for this table.

This table contains information about the temperature on a certain day.

Write a solution to find all dates' Id with higher temperatures compared to its previous dates $($yesterday$).$

Return the result table in any order.

The result format is in the following example.

Example $1$:

Input:

Weather table:

$+----+------------+-------------+$

$|$ id $|$ recordDate $|$ temperature $|$

$+----+------------+-------------+$

$|1|2015-01-01|10|$

$|2|2015-01-02|25|$

$|3|2015-01-03|20|$

$|4|2015-01-04|30|$

$+----+------------+-------------+$

Output:

$+----+$

$|$ id $|$

$+----+$

$|2|$

$|4|$

$+----+$

Explanation:

In $2015-01-02,$ the temperature was higher than the previous day $(10->25).$

In $2015-01-04,$ the temperature was higher than the previous day $(20->30).$