/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

7 votes195 views2 answers
Add column table pl sql
SQL
0 vote197 views1 answer
Postgresql CREATE EXTENSION pgcrypto
SQL
0 vote248 views1 answer
Error Code: 1267. Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=' 0.000 sec
SQL
1 vote238 views1 answer
Insert many to many sql
SQL
0 vote194 views1 answer
Min mysql
SQL
0 vote216 views1 answer
Tsql find procedure with name
SQL
1 vote190 views1 answer
Import in mysql without a software
SQL
0 vote212 views1 answer
Postegresql update to null
SQL
2 votes206 views2 answers
Mysql alter column default
SQL
0 vote296 views1 answer
Compare strings lexicographically in sql
SQL