/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

1 vote108 views1 answer
Jooq convert using gbk
SQL
2 votes109 views1 answer
Postgresql add entry to table
SQL
0 vote110 views2 answers
Postgresql gset
SQL
0 vote116 views1 answer
What does the -p flag do in mysql cli
SQL
0 vote109 views1 answer
Mysql begin statement
SQL
1 vote113 views5 answers
Sql 2nd highest salary
SQL
2 votes119 views1 answer
Alter table add column and foreign key mysql
SQL
3 votes116 views2 answers
Plsql print
SQL
3 votes123 views1 answer
Oracle function return
SQL
0 vote110 views1 answer
Order by with where clause in mysql
SQL