select
	PREFECTURE.PF_CODE AS '都道府県コード'
	,PREFECTURE.PF_NAME AS '都道府県名'
	,SUM(case when  POPU_TRANSITION.SURVEY_YEAR = 2015 THEN POPU_TRANSITION.TOTAL_AMT ELSE 0 END) AS '総人口2015年'
	,SUM(case when  POPU_TRANSITION.SURVEY_YEAR = 2020 THEN POPU_TRANSITION.TOTAL_AMT ELSE 0 END) AS '総人口2020年'
	,round(100*cast(SUM(case when  POPU_TRANSITION.SURVEY_YEAR = 2020 THEN POPU_TRANSITION.TOTAL_AMT ELSE 0 END) as real)/cast(SUM(case when  POPU_TRANSITION.SURVEY_YEAR = 2015 THEN POPU_TRANSITION.TOTAL_AMT ELSE 0 END) as real),0) AS '人口増加率'
from POPU_TRANSITION
left join PREFECTURE
on POPU_TRANSITION.PF_CODE = PREFECTURE.PF_CODE
group by
    PREFECTURE.PF_CODE
    ,PREFECTURE.PF_NAME
having
	cast(SUM(case when  POPU_TRANSITION.SURVEY_YEAR = 2020 THEN POPU_TRANSITION.TOTAL_AMT ELSE 0 END) as real)/cast(SUM(case when  POPU_TRANSITION.SURVEY_YEAR = 2015 THEN POPU_TRANSITION.TOTAL_AMT ELSE 0 END) as real) > 1
order by
	5 desc,1