/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

4 votes137 views1 answer
Add constraint fk
SQL
0 vote168 views1 answer
What are the advantages of MySQL when compared with Oracle?
SQL
3 votes191 views2 answers
How to View column names of a table in SQL
SQL
0 vote137 views1 answer
Dapper : operator does not exist: integer = integer[]'
SQL
0 vote230 views1 answer
Add user mysql wordpress
SQL
1 vote234 views1 answer
Truncate table in postgresql and reset id
SQL
0 vote149 views1 answer
Connect to nginx server mysql remotly
SQL
4 votes140 views2 answers
Sql vs mysql
SQL
0 vote147 views1 answer
Update table sql multiple set
SQL
0 vote282 views2 answers
SQL SERVER ORDER BY DATE NULL LAST
SQL