select PERTBL.PF_CODE as '都道府県コード', 
P.PF_NAME as '都道府県名',
PERTBL.AMT_2015 as '総人口2015年',
PERTBL.AMT_2020 as '総人口2020年',
PERTBL.PERCENT as '人口増加率'
from (select POPU_2020.PF_CODE, 
       POPU_2015.TOTAL_AMT as AMT_2015, 
       POPU_2020.TOTAL_AMT as AMT_2020, 
       ROUND(CAST(POPU_2020.TOTAL_AMT as REAL) / POPU_2015.TOTAL_AMT * 100) as percent
from (select SURVEY_YEAR, PF_CODE, TOTAL_AMT from POPU_TRANSITION where SURVEY_YEAR=2015) POPU_2015, 
     (select SURVEY_YEAR, PF_CODE, TOTAL_AMT from POPU_TRANSITION where SURVEY_YEAR=2020) POPU_2020
where POPU_2020.PF_CODE=POPU_2015.PF_CODE
) PERTBL,
PREFECTURE P
where PERTBL.PERCENT>=100
  and PERTBL.PF_CODE=P.PF_CODE
order by PERTBL.PERCENT desc,
PERTBL.PF_CODE asc;