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