select
    po.PF_CODE '都道府県コード',
    pr.PF_NAME '都道府県名',
    po.TOTAL_AMT '総人口2015年',
    po2.TOTAL_AMT '総人口2020年',
    round(100.0 * po2.TOTAL_AMT / po.TOTAL_AMT, 0) '人口増加率'    
from (
    select *
    from POPU_TRANSITION
    where SURVEY_YEAR = 2015
    ) po
inner join (
    select *
    from POPU_TRANSITION
    where SURVEY_YEAR = 2020
    ) po2
    on po.PF_CODE == po2.PF_CODE
    and po.TOTAL_AMT < po2.TOTAL_AMT
left join PREFECTURE pr
    on po.PF_CODE == pr.PF_CODE
order by 5 desc, 1