select 
PT.PF_CODE as 都道府県コード,
PR.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年,
round(cast(sum(case when SURVEY_YEAR ='2020' then TOTAL_AMT else 0 end) as real)*100
/cast(sum(case when SURVEY_YEAR ='2015' then TOTAL_AMT else 0 end) as real),0) as 人口増加率
from POPU_TRANSITION as PT
    inner join PREFECTURE as PR
    on PT.PF_CODE=PR.PF_CODE
group by 都道府県コード
having 人口増加率 >= 100
order by 人口増加率 desc,都道府県コード asc