/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

10 votes133 views3 answers
Sql select between two dates
SQL
0 vote83 views2 answers
Denormalization in sql
SQL
1 vote144 views1 answer
Psql search table
SQL
0 vote122 views1 answer
Oracle grant create job
SQL
0 vote124 views1 answer
Sql select most frequent value in group
SQL
0 vote136 views1 answer
Mysql docker image arjun
SQL
-1 vote125 views1 answer
Pl/sql how to delete a trigger
SQL
0 vote131 views1 answer
Postgres where
SQL
21 votes126 views1 answer
SQL cheat sheet pdf
SQL
4 votes140 views2 answers
Installing sql on ubuntu
SQL