select
    PREFECTURE.PF_CODE as "都道府県コード",
    PF_NAME as "都道府県名",
    "総人口2015年",
    "総人口2020年",
    round(cast("総人口2020年" as real) / cast("総人口2015年" as real) * 100.0, 0) as "人口増加率"
from
    (select PF_CODE, TOTAL_AMT as "総人口2015年" from POPU_TRANSITION where SURVEY_YEAR = 2015) as Y2015
    inner join (select PF_CODE, TOTAL_AMT as "総人口2020年" from POPU_TRANSITION where SURVEY_YEAR = 2020) as Y2020
        on Y2015.PF_CODE = Y2020.PF_CODE
    inner join PREFECTURE
        on PREFECTURE.PF_CODE = Y2015.PF_CODE
where "総人口2020年" > "総人口2015年"
order by "人口増加率" desc, cast("都道府県コード" as integer) asc;