/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 vote273 views1 answer
Mysql max connections exceeded max_connections_per_hour
SQL
0 vote290 views1 answer
Sql output select
SQL
2 votes278 views1 answer
Drop all database tables oracle sql developer
SQL
1 vote232 views1 answer
Into sql
SQL
0 vote556 views1 answer
How to connect .sql data set to powerbi
SQL
1 vote269 views1 answer
Increase date by one day in sql oracle
SQL
11 votes290 views3 answers
Pl sql example
SQL
3 votes257 views1 answer
Oracle function
SQL
0 vote295 views1 answer
What is initial catalog in sql connection string
SQL
0 vote296 views2 answers
List all constraints in postgres
SQL