/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 votes135 views1 answer
Cast string to datetime mysql
SQL
9 votes140 views2 answers
Convert data type in sql
SQL
0 vote139 views1 answer
Sql select all tables from database change url
SQL
1 vote265 views1 answer
Import sql file from laravel
SQL
0 vote165 views1 answer
Many rows to 1 string mysql
SQL
4 votes122 views1 answer
Invalid reference to FROM-clause entry for table "unidades
SQL
0 vote167 views1 answer
Query to insert image
SQL
0 vote144 views1 answer
Mysql 8 error on identified by
SQL
0 vote132 views1 answer
Dns slave zone convert
SQL
10 votes132 views4 answers
How to alter table name in mysql
SQL