/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 vote186 views1 answer
Sql server inner join convert collation
SQL
0 vote199 views1 answer
Show size of all tables postgres
SQL
0 vote205 views4 answers
Mysql replace regex
SQL
4 votes197 views1 answer
SQL find text in SP
SQL
1 vote202 views1 answer
Best sql course
SQL
0 vote145 views1 answer
Microsoft sql server management studio clear cache
SQL
2 votes199 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly.
SQL
0 vote214 views1 answer
Regex any word except sql
SQL
5 votes198 views3 answers
Postgres show databases
SQL
9 votes191 views2 answers
Default number in sql
SQL