SELECT
 POP.PF_CODE as 都道府県コード
 ,PRE.PF_NAME as 都道府県名
 ,POP.TOTAL_AMT as '総人口2015年'
 ,POP20.TOTAL_AMT as '総人口2020年'
 ,ROUND(100.0*POP20.TOTAL_AMT/POP.TOTAL_AMT) as 人口増加率
FROM
 POPU_TRANSITION POP
JOIN
 POPU_TRANSITION POP20
ON
 POP.PF_CODE = POP20.PF_CODE
 AND POP20.SURVEY_YEAR = 2020
JOIN
 PREFECTURE PRE
ON
 POP.PF_CODE = PRE.PF_CODE
WHERE
 POP.SURVEY_YEAR = 2015
 AND 人口増加率 >= 100
ORDER BY
 人口増加率 DESC
 ,POP.PF_CODE ASC