select
    pf.PF_CODE as 都道府県コード,
    pf.PF_NAME as 都道府県名,
    max(case when pt.SURVEY_YEAR = 2015 then pt.TOTAL_AMT end) as 総人口2015年,
    max(case when pt.SURVEY_YEAR = 2020 then pt.TOTAL_AMT end) as 総人口2020年,
    round(
        cast(max(case when pt.SURVEY_YEAR = 2020 then pt.TOTAL_AMT end) as float) * 100 / max(case when pt.SURVEY_YEAR = 2015 then pt.TOTAL_AMT end),
        0
    )as 人口増加率
from
    POPU_TRANSITION as pt
inner join
    PREFECTURE as pf
    on pt.PF_CODE = pf.PF_CODE
group by
    1,2
order by
    5 desc,1