/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 vote164 views1 answer
Mysql select where field is a value
SQL
33 votes144 views2 answers
Postgres how to add field created at
SQL
2 votes178 views1 answer
Sql OR
SQL
3 votes144 views1 answer
Postgresql if null then 0
SQL
3 votes164 views1 answer
Oracle revoke
SQL
1 vote157 views1 answer
Oracle grant on all tables in schema
SQL
1 vote152 views1 answer
How to find median of a column sql
SQL
0 vote202 views1 answer
Mysql faster delete
SQL
5 votes155 views2 answers
Mysql drop table cascade
SQL
7 votes181 views2 answers
Create index mysql cli
SQL