populations
table to perform a self-join to calculate the percentage increase in population from 2010 to 2015 for each country code!populations
table to itself, you can alias populations
as p1
and also populations
as p2
. This is good practice whenever you are aliasing and your tables have the same first letter. Note that you are required to alias the tables with self-joins.