*/ WITH WEATHER_CTE AS ( SELECT *, LAG (TEMPERATURE,1)OVER (ORDER BY RECORDDATE) AS PREVIOUS_DATE_TEMPERATURE, LAG (RECORDDATE,1)OVER (ORDER BY RECORDDATE) AS PREVIOUS_DAY FROM WEATHER ) SELECT ID ...

Temp table -temporary temp tables1)they can be created at run time in tempdb database.2)ddl,dml statements like select,update which can be executed on regular tables can be done on temporary tables.

A companion repository for the MySQL Window Functions training at CBT Nuggets. - cbttrevor/mysql-window-functions ...