select
    p.PF_CODE as '都道府県コード',
    p.PF_NAME as '都道府県名',
    t2015.TOTAL_AMT as '総人口2015年',
    t2020.TOTAL_AMT as '総人口2020年',
    round(cast(t2020.TOTAL_AMT as real) / cast(t2015.TOTAL_AMT as real) * 100) as '人口増加率'
from
    PREFECTURE as p
    left outer join (select * from POPU_TRANSITION where SURVEY_YEAR = 2015) as t2015
    on p.PF_CODE = t2015.PF_CODE
    left outer join (select * from POPU_TRANSITION where SURVEY_YEAR = 2020) as t2020
    on p.PF_CODE = t2020.PF_CODE
where
    t2020.TOTAL_AMT > t2015.TOTAL_AMT
order by
    人口増加率 desc,
    p.PF_CODE asc
;