select 
    b.PF_CODE,
    b.PF_NAME,
    sum(case when a.SURVEY_YEAR = 2015 then a.TOTAL_AMT else 0 end) as "総人口2015年",
    sum(case when a.SURVEY_YEAR = 2020 then a.TOTAL_AMT else 0 end) as "総人口2020年",
    ROUND(
        (cast(sum(case when a.SURVEY_YEAR = 2020 then a.TOTAL_AMT else 0 end) as REAL) / cast(sum(case when a.SURVEY_YEAR = 2015 then a.TOTAL_AMT else 0 end) as REAL)*100)) as "増加率"
from 
    POPU_TRANSITION a inner join PREFECTURE b
    on a.PF_CODE = b.PF_CODE
    and a.SURVEY_YEAR in (2015, 2020)
group by b.PF_CODE
having
  総人口2015年 < 総人口2020年
order by 
 増加率 desc,
 a.PF_CODE
;