select
 a.PF_CODE AS 都道府県コード
,a.PF_NAME AS 都道府県名
,b.TOTAL_AMT AS 総人口2015年
,c.TOTAL_AMT AS 総人口2020年
,round(cast(c.TOTAL_AMT AS real)/cast(b.TOTAL_AMT AS real)*100,0) AS 人口増加率
from PREFECTURE a
left join POPU_TRANSITION b
 on b.PF_CODE = a.PF_CODE
and b.SURVEY_YEAR = 2015
left join POPU_TRANSITION c
 on c.PF_CODE = a.PF_CODE
and c.SURVEY_YEAR = 2020
where 1=1
and b.TOTAL_AMT < c.TOTAL_AMT
order by 人口増加率 desc, a.PF_CODE asc;