/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

3 votes176 views2 answers
Install mysql powershell
SQL
0 vote241 views2 answers
Fanyi
SQL
1 vote191 views3 answers
Connection string mysql
SQL
0 vote194 views1 answer
Codigo crear tablas sql server
SQL
0 vote182 views1 answer
Ajouter une clé etrangere mysql
SQL
0 vote610 views1 answer
How to connect .sql data set to powerbi
SQL
0 vote263 views1 answer
Variable 'sql_mode' can't be set to the value of 'no_auto_create_user'
SQL
0 vote172 views1 answer
Odd record sql query
SQL
9 votes194 views1 answer
Alter table column change data type to text mysql
SQL
0 vote259 views1 answer
Mysql collation portugues brasil
SQL