select
    pop.PF_CODE as 都道府県コード
    ,pre.PF_NAME as 都道府県名
    ,sum(case when SURVEY_YEAR = 2015 then TOTAL_AMT else 0 end) as 総人口2015年
    ,sum(case when SURVEY_YEAR = 2020 then TOTAL_AMT else 0 end) as 総人口2020年
    ,case when coalesce(sum(case when SURVEY_YEAR = 2015 then TOTAL_AMT else 0 end),0) = 0 then 0
           else round(100.0 * coalesce(sum(case when SURVEY_YEAR = 2020 then TOTAL_AMT else 0 end),0)
                                  / coalesce(sum(case when SURVEY_YEAR = 2015 then TOTAL_AMT else 0 end),0)) end as 人口増加率
from POPU_TRANSITION pop
    left join PREFECTURE pre
        on pop.PF_CODE = pre.PF_CODE
group by 都道府県コード, 都道府県名
having 人口増加率 > 100.00
order by 人口増加率 desc, 都道府県コード