select 
p.PF_CODE as '都道府県コード',
r.PF_NAME as '都道府県名',
(Select sum(TOTAL_AMT) From POPU_TRANSITION 
where SURVEY_YEAR  = 2015 AND p.PF_CODE = POPU_TRANSITION.PF_CODE) as '総人口2015年',
(Select sum(TOTAL_AMT) From POPU_TRANSITION 
where SURVEY_YEAR  = 2020 AND p.PF_CODE = POPU_TRANSITION.PF_CODE) as '総人口2020年',

Round((Select cast(sum(TOTAL_AMT) as real) From POPU_TRANSITION 
where SURVEY_YEAR  = 2020 AND p.PF_CODE = POPU_TRANSITION.PF_CODE)/
(Select cast(sum(TOTAL_AMT) as real) From POPU_TRANSITION 
where SURVEY_YEAR  = 2015 AND p.PF_CODE = POPU_TRANSITION.PF_CODE),2)*100 as '人口増加率'
From
POPU_TRANSITION As p
Left join 
PREFECTURE as r On p.PF_CODE = r.PF_CODE 

where
Round((Select cast(sum(TOTAL_AMT) as real) From POPU_TRANSITION 
where SURVEY_YEAR  = 2020 AND p.PF_CODE = POPU_TRANSITION.PF_CODE)/
(Select cast(sum(TOTAL_AMT) as real) From POPU_TRANSITION 
where SURVEY_YEAR  = 2015 AND p.PF_CODE = POPU_TRANSITION.PF_CODE),2)*100  >= 100

group By 
p.PF_CODE

Order By
人口増加率 desc,
p.PF_CODE