SELECT
PREFECTURE.PF_CODE AS 都道府県コード,
PF_NAME AS 都道府県名,
POPU15.TOTAL_AMT AS 総人口2015年,
POPU20.TOTAL_AMT AS 総人口2020年,
ROUND(100.0 * POPU20.TOTAL_AMT/POPU15.TOTAL_AMT) AS 人口増加率
FROM
POPU_TRANSITION POPU15,
POPU_TRANSITION POPU20,
PREFECTURE
WHERE
POPU15.PF_CODE = PREFECTURE.PF_CODE AND
POPU15.SURVEY_YEAR = 2015 AND
POPU20.PF_CODE = PREFECTURE.PF_CODE AND
POPU20.SURVEY_YEAR = 2020 AND
POPU20.TOTAL_AMT > POPU15.TOTAL_AMT
ORDER BY
人口増加率 DESC,
都道府県コード