/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

0 vote264 views1 answer
Create relationship with betwen two tables in postgersql
SQL
2 votes290 views2 answers
Postgres timestamp to datetime
SQL
3 votes267 views2 answers
To_char oracle
SQL
3 votes280 views1 answer
Alembic.util.exc.CommandError: Target database is not up to date.
SQL
1 vote261 views1 answer
Psql client write to bash variable
SQL
0 vote267 views1 answer
Mysql min value row
SQL
1 vote289 views1 answer
Increase existing date in sql
SQL
0 vote271 views1 answer
Install squirrel sql ubuntu
SQL
0 vote256 views1 answer
Sub blocks in sql
SQL
3 votes260 views1 answer
Oracle get trigger ddl
SQL