/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 vote167 views1 answer
Select inside insert query
SQL
0 vote162 views2 answers
Starts and end with vowel sql
SQL
1 vote149 views2 answers
How to drop a unique constraint in sql
SQL
0 vote150 views1 answer
Pl sql join 3 tables
SQL
4 votes140 views1 answer
Add constraint fk
SQL
0 vote178 views2 answers
Postgres isnull
SQL
0 vote149 views1 answer
Allow external access to mysql
SQL
2 votes157 views1 answer
Add new column not null sql server
SQL
0 vote163 views1 answer
Query for backup a database at another location in file system
SQL
2 votes167 views1 answer
Sql skip the first row
SQL