/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

15 votes144 views2 answers
Open postgress in terminal mac
SQL
0 vote130 views1 answer
Postgresql create user roles
SQL
1 vote139 views2 answers
Difference between in and between in sql
SQL
0 vote149 views1 answer
Java check if something is in mysql table
SQL
1 vote130 views3 answers
Mariadb add foreign key
SQL
23 votes107 views3 answers
Mysqldump
SQL
23 votes123 views6 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
-1 vote180 views1 answer
Difference berween database and data base management system
SQL
0 vote157 views1 answer
Space not removing from column in sql
SQL
1 vote134 views1 answer
How to see logical reads in sql server
SQL