SELECT
    PREFECTURE.PF_CODE as "都道府県コード",
    PREFECTURE.PF_NAME as "都道府県名",
    PT_2015.TOTAL_AMT as "総人口2015年",
    PT_2020.TOTAL_AMT as "総人口2020年",
    round( 100 * cast(PT_2020.TOTAL_AMT as real) / cast(PT_2015.TOTAL_AMT as real) , 0)  as "人口増加率"
from
    POPU_TRANSITION as PT_2015
join
    POPU_TRANSITION as PT_2020 on PT_2020.SURVEY_YEAR = 2020 and PT_2015.PF_CODE = PT_2020.PF_CODE
join
    PREFECTURE on PT_2015.PF_CODE = PREFECTURE.PF_CODE
where
    PT_2015.SURVEY_YEAR = 2015
and
    PT_2020.TOTAL_AMT > PT_2015.TOTAL_AMT
order by
    人口増加率 desc, PREFECTURE.PF_CODE asc