/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

18 votes373 views4 answers
Mysql current date between two dates
SQL
3 votes413 views2 answers
Update part of a string in mysql
SQL
0 vote368 views1 answer
T-SQL Create Trigger
SQL
1 vote375 views1 answer
Join first name and last name sql
SQL
0 vote384 views1 answer
Mysql select random rows large table
SQL
0 vote348 views1 answer
T sql return on letters only
SQL
0 vote390 views1 answer
Influxdb list all tags for a measurement
SQL
1 vote352 views1 answer
Create new table in SQL from old table with data
SQL
2 votes381 views1 answer
Metasploit start postgresql
SQL
0 vote377 views1 answer
Sql server on mac m1
SQL