select
    PREFECTURE.PF_CODE as 都道府県コード,
    PREFECTURE.PF_NAME as都道府県名,
    p2015.TOTAL_AMT as 総人口2015年,
    p2020.TOTAL_AMT as 総人口2020年,
    round(p2020.TOTAL_AMT * 100.0 / p2015.TOTAL_AMT) as 人口増加率
from PREFECTURE
inner join POPU_TRANSITION as p2015
on p2015.PF_CODE = PREFECTURE.PF_CODE and p2015.SURVEY_YEAR = 2015
inner join POPU_TRANSITION as p2020
on p2020.PF_CODE = PREFECTURE.PF_CODE and p2020.SURVEY_YEAR = 2020
where p2020.TOTAL_AMT > p2015.TOTAL_AMT
order by 人口増加率 desc, PREFECTURE.PF_CODE