/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 vote175 views4 answers
Convert databse to achieve log mode oracle
SQL
0 vote180 views1 answer
Sqlalchemy get schema from database
SQL
0 vote158 views1 answer
How to update rows from a table when certain conditions are met in mysql
SQL
0 vote167 views1 answer
Postgres week number
SQL
0 vote178 views2 answers
Install phoenix
SQL
0 vote183 views1 answer
000webhost database values insert
SQL
11 votes133 views1 answer
Reset identity sql server
SQL
0 vote168 views1 answer
How to check replication lag in mySQL
SQL
0 vote198 views1 answer
Vs 2019 connect to local mysql database
SQL
0 vote186 views1 answer
Ajouter une clé etrangere mysql
SQL