/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

1 vote188 views1 answer
Can not connect to mysql server
SQL
0 vote198 views1 answer
Check if database exists sql
SQL
0 vote181 views2 answers
List all the items that have not been part of any purchase order. sql
SQL
0 vote185 views1 answer
Sql server alter table add column datetime default current_timestamp
SQL
0 vote217 views1 answer
Mengatasi error mysqldump: [ERROR] unknown option '--no-beep'
SQL
1 vote215 views1 answer
Floor function in sql oracle
SQL
1 vote195 views1 answer
Lpad function in sql oracle
SQL
0 vote212 views1 answer
How to generate ids in sql
SQL
0 vote193 views4 answers
Change schema in sql server
SQL
1 vote208 views2 answers
Foreign key set 0
SQL