select 
    p.PF_CODE as "都道府県コード",
    p.PF_NAME as "都道府県名",
    po_15.TOTAL_AMT as "総人口2015年",
    po_20.TOTAL_AMT as "総人口2020年",
    ROUND((CAST(po_20.TOTAL_AMT as real) / po_15.TOTAL_AMT) * 100, 0) as "人口増加率"
from 
    PREFECTURE as p
inner join
    (
        select
            PF_CODE,
            TOTAL_AMT 
        from 
            POPU_TRANSITION
        where SURVEY_YEAR = 2015
    ) as po_15
on
    po_15.PF_CODE = p.PF_CODE
inner join
    (
        select
            PF_CODE,
            TOTAL_AMT 
        from 
            POPU_TRANSITION
        where SURVEY_YEAR = 2020
    ) as po_20
on
    po_20.PF_CODE = p.PF_CODE
where 
    "総人口2015年" < "総人口2020年"
order by
    "人口増加率" desc,
    "都道府県コード" asc;