select pre.PF_CODE as '都道府県コード'
    , PF_NAME as '都道府県名'
    , sub1.TOTAL_AMT as '総人口2015年'
    , sub2.TOTAL_AMT as '総人口2020年'
    , round(cast(sub2.TOTAL_AMT as float)/cast(sub1.TOTAL_AMT as float) * 100 , 0)
    as '人口増加率'
from PREFECTURE as pre
join (select SURVEY_YEAR, PF_CODE, TOTAL_AMT
    from POPU_TRANSITION
    where SURVEY_YEAR = 2015
    ) as sub1
on pre.PF_CODE = sub1.PF_CODE
join (select SURVEY_YEAR, PF_CODE, TOTAL_AMT
    from POPU_TRANSITION
    where SURVEY_YEAR = 2020
    ) as sub2
on pre.PF_CODE = sub2.PF_CODE
where sub1.TOTAL_AMT < sub2.TOTAL_AMT
order by 5 desc, 1 asc;