select
    pref.pf_code as "都道府県コード",
    PF_NAME as "都道府県名",
    pop2015.TOTAL_AMT as "総人口2015年",
    pop2020.TOTAL_AMT as "総人口2020年",
    round( cast(pop2020.TOTAL_AMT as real)*100.0/cast(pop2015.TOTAL_AMT as REAL)) as "人口増加率"
from
    PREFECTURE as pref
    INNER JOIN POPU_TRANSITION as pop2015
        ON pref.pf_code = pop2015.pf_code
    INNER JOIN POPU_TRANSITION as pop2020
        ON pref.pf_code = pop2020.pf_code and pop2020.SURVEY_YEAR = 2020

where
    pop2015.SURVEY_YEAR = 2015 and
    pop2015.TOTAL_AMT < pop2020.TOTAL_AMT
 order by
    "人口増加率" desc, "都道府県コード"