/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

-2 votes275 views3 answers
Sqlite reset autoincrement
SQL
0 vote298 views1 answer
How to list function in psql
SQL
0 vote282 views1 answer
How to stop all connections to a psql 12 database?
SQL
1 vote295 views1 answer
Sql server epoch to datetime
SQL
0 vote319 views1 answer
Mysql Puede ser solamente un campo automatico y este debe ser definido como una clave
SQL
1 vote303 views1 answer
Oracle check table lock
SQL
3 votes274 views1 answer
Oracle user quota on tablespace
SQL
1 vote296 views3 answers
Get all tables postgres
SQL
1 vote361 views2 answers
Begin transaction sql
SQL
0 vote280 views4 answers
Database stuck at restoring state
SQL