/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 vote173 views1 answer
PL SQL MODIFY COLUMN NME
SQL
14 votes197 views3 answers
Inner join sql oracle
SQL
0 vote171 views1 answer
Concatenate columns in table
SQL
14 votes181 views2 answers
How to auto increment in sql
SQL
0 vote185 views1 answer
Postgres data location
SQL
2 votes166 views1 answer
Node and mysql like
SQL
0 vote220 views1 answer
C# sql transaction multiple connections
SQL
0 vote185 views1 answer
Mariadb alter table add column if not exists example
SQL
0 vote186 views1 answer
Sql counter column
SQL
7 votes171 views2 answers
Mysql db size
SQL