/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 vote293 views1 answer
Show size of all tables postgres
SQL
0 vote291 views1 answer
Mysql pad zeros
SQL
0 vote307 views1 answer
Arithmetic expression in sql
SQL
0 vote288 views1 answer
Using GROUP BY in MySQL Join Table
SQL
1 vote316 views1 answer
Where not in array sql
SQL
0 vote307 views1 answer
EneratingSchemaError: Some errors occurred while generating GraphQL schema: Type Query must define one or more fields.
SQL
13 votes282 views3 answers
Sql online code
SQL
1 vote496 views3 answers
Sql subquery
SQL
0 vote311 views1 answer
In query in sql
SQL
2 votes293 views1 answer
Add new column not null sql server
SQL