/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

4 votes266 views3 answers
Mysql modify foreign key
SQL
0 vote302 views1 answer
"/** MySQL database password */" ext:txt | ext:cfg | ext:env | ext:ini
SQL
0 vote276 views1 answer
C# add a textbox in mysql select
SQL
-1 vote231 views1 answer
How to create script to connect to oracle database and run query
SQL
0 vote274 views1 answer
Sql query to get column names and data types in sql server
SQL
7 votes278 views2 answers
Mysql get year from date
SQL
31 votes286 views4 answers
Mysql grant execute
SQL
0 vote257 views1 answer
Deny select insert update delete sql
SQL
2 votes300 views2 answers
Mysql does sentence contain word
SQL
-1 vote284 views1 answer
Can pandas fetch data from sql
SQL