/SQL/The differnece between to values in sql

The differnece between to values in sql

SELECT 	
city,
	year,
      population_needing_house,
      LAG(population_needing_house)
      OVER (PARTITION BY city ORDER BY year ) AS previous_year
      population_needing_house - LAG(population_needing_house)
 	OVER (PARTITION BY city ORDER BY year ) AS difference_previous_year
FROM 	housing
ORDER BY city, year

Source: learnsql.com

Similar codes

0 vote305 views1 answer
Create new table pl sql
SQL
17 votes364 views3 answers
Postgresql list users
SQL
0 vote334 views1 answer
Ceil upto 2 decimal place mysql
SQL
3 votes322 views1 answer
Sql online test questions and answers
SQL
0 vote306 views1 answer
Oracle flush Shared Pool
SQL
5 votes337 views1 answer
Oracle add time to date
SQL
0 vote258 views1 answer
Microsoft sql server management studio clear cache
SQL
0 vote394 views1 answer
Redshift running queries
SQL
0 vote307 views1 answer
Mysql find the row ites of the hoghest value at on column
SQL
0 vote340 views1 answer
Oracle current date minus 1 day
SQL