select
    PREFECTURE.PF_CODE as 都道府県コード,
    PREFECTURE.PF_NAME as 都道府県名,
    TOTAL_AMT2015.TOTAL_AMT as 総人口2015年,
    TOTAL_AMT2020.TOTAL_AMT as 総人口2020年,
    round(cast(TOTAL_AMT2020.total_amt as real) / cast(TOTAL_AMT2015.total_amt as real) * 100, 0) as 人口増加率
from PREFECTURE
inner join POPU_TRANSITION as TOTAL_AMT2015
on PREFECTURE.PF_CODE = TOTAL_AMT2015.PF_CODE and TOTAL_AMT2015.SURVEY_YEAR = 2015
inner join POPU_TRANSITION as TOTAL_AMT2020
on PREFECTURE.PF_CODE = TOTAL_AMT2020.PF_CODE and TOTAL_AMT2020.SURVEY_YEAR = 2020
where 総人口2015年 < 総人口2020年
order by 人口増加率 desc, 都道府県コード