select 
  T.PF_CODE as 都道府県コード,
  P.PF_NAME as  都道府県名,
  MAX(CASE WHEN SURVEY_YEAR = 2015 THEN TOTAL_AMT*1.0 END) as 総人口2015年,
  MAX(CASE WHEN SURVEY_YEAR = 2020 THEN TOTAL_AMT*1.0 END) as 総人口2020年,
  round(MAX(CASE WHEN SURVEY_YEAR = 2020 THEN TOTAL_AMT*1.0 END)*100/MAX(CASE WHEN SURVEY_YEAR = 2015 THEN TOTAL_AMT*1.0 END), 0) as 人口増加率
from
  POPU_TRANSITION T
join
  PREFECTURE P
on
  T.PF_CODE = P.PF_CODE
group by
  T.PF_CODE
having
  round(MAX(CASE WHEN SURVEY_YEAR = 2020 THEN TOTAL_AMT*1.0 END)*100/MAX(CASE WHEN SURVEY_YEAR = 2015 THEN TOTAL_AMT*1.0 END), 0) >= 100
order by
  5 DESC, 1;