select
    P.PF_CODE as "都道府県コード",
    P.PF_NAME as "都道府県名",
    PT.A2015 as "総人口2015年",
    PT.A2020 as "総人口2020年",
    ROUND(PT.A2020 * 100.0 / PT.A2015, 0) as "人口増加率"
from (
    select
        PF_CODE,
        max(case SURVEY_YEAR when 2015 then TOTAL_AMT else 0 end) as "A2015",
        max(case SURVEY_YEAR when 2020 then TOTAL_AMT else 0 end) as "A2020"
    from POPU_TRANSITION
    group by PF_CODE
) PT
left join PREFECTURE P on PT.PF_CODE = P.PF_CODE
where PT.A2020 > PT.A2015
order by "人口増加率" desc, "都道府県コード"
;