/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 vote221 views4 answers
Fatal database postgres does not exist
SQL
10 votes190 views1 answer
Oracle view dependencies
SQL
0 vote232 views1 answer
Postgresql select fast check no rows
SQL
0 vote301 views1 answer
ORA-32794: cannot drop a system-generated sequence
SQL
0 vote269 views1 answer
Sql query wordpress export post
SQL
0 vote222 views1 answer
MySql get primary keys of table
SQL
2 votes240 views1 answer
Set username and password for postgresql database
SQL
0 vote211 views1 answer
Como leer datos de mysql esp32
SQL
0 vote257 views1 answer
Mysql Selected All Duplicate Rows
SQL
0 vote245 views1 answer
Node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v72-win32-x64.tar.gz
SQL