select
    P.PF_CODE as '都道府県コード'
    ,P.PF_NAME as '都道府県名'
    ,POP2015 as '総人口2015年'
    ,POP2020 as '総人口2020年'
    ,round(100.0 * POP2020/POP2015) as '人口増加率'
from
    PREFECTURE P
    inner join
        (
        select
            PF_CODE
            ,sum(case when SURVEY_YEAR='2015' then TOTAL_AMT end) as POP2015
            ,sum(case when SURVEY_YEAR='2020' then TOTAL_AMT end) as POP2020
        from
            POPU_TRANSITION
        group by PF_CODE
        ) T
        on
            P.PF_CODE = T.PF_CODE
order by 3 desc ,1
;