/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 vote333 views1 answer
Formatting code with SQL Developer
SQL
0 vote314 views1 answer
Go install mysql
SQL
3 votes368 views1 answer
Laravel paginate raw sql
SQL
1 vote328 views1 answer
Create index concurrently postgres
SQL
9 votes316 views4 answers
How to remove duplicate in sql
SQL
12 votes350 views4 answers
Psql command not found
SQL
0 vote371 views1 answer
Sql sort ages
SQL
0 vote326 views1 answer
Plsql check for string in numeric
SQL
1 vote333 views1 answer
Show all event schedular on mysql
SQL
0 vote313 views1 answer
Phpmyadmin mysql conflict
SQL