/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 votes233 views5 answers
Tablespace ORACLE
SQL
0 vote231 views1 answer
Select the date 30 days less that the todays date sql request
SQL
3 votes318 views4 answers
Sql interview questions
SQL
1 vote185 views1 answer
ALL_TAB_PARTITIONS
SQL
2 votes190 views1 answer
Sql like variable
SQL
6 votes2.2K views1 answer
Sql select second max
SQL
-1 vote224 views1 answer
An error occurred while installing mysql (2.9.1), and Bundler cannot continue
SQL
0 vote207 views1 answer
Rabbitmq ui not working
SQL
0 vote241 views1 answer
Ran rails db:migrate and got == 20210620104415 DeviseCreateUsers: migrating ================================ -- create_table(:users) rails aborted! StandardError: An error has occurred, this and all later migrations canceled: SQLite3::SQLE
SQL
2 votes181 views1 answer
How to delete columns in sql
SQL