select  pop.PF_CODE "都道府県コード"
,       pre.PF_NAME "都道府県名"
,       SUM(CASE WHEN pop.SURVEY_YEAR = 2015 THEN pop.TOTAL_AMT ELSE NULL END) "総人口2015年"
,       SUM(CASE WHEN pop.SURVEY_YEAR = 2020 THEN pop.TOTAL_AMT ELSE NULL END) "総人口2020年"
,       ROUND((SUM(CASE WHEN pop.SURVEY_YEAR = 2020 THEN pop.TOTAL_AMT ELSE NULL END) * 100.00) / (SUM(CASE WHEN pop.SURVEY_YEAR = 2015 THEN pop.TOTAL_AMT ELSE NULL END) + SUM(CASE WHEN pop.SURVEY_YEAR = 2020 THEN pop.TOTAL_AMT ELSE NULL END)), 2) "人口増加率"
from POPU_TRANSITION pop
inner join PREFECTURE pre
   on pre.PF_CODE = pop.PF_CODE
where pop.SURVEY_YEAR IN (2015, 2020)
group by pop.PF_CODE, pre.PF_NAME
order by "人口増加率" desc, "都道府県コード"