SELECT
PF.PF_CODE as 都道府県コード,
PF.PF_NAME as 都道府県名,
PO2015.TOTAL_AMT as 総人口2015年,
PO2020.TOTAL_AMT as 総人口2020年,
ROUND(CAST(PO2020.TOTAL_AMT as REAL)/CAST(PO2015.TOTAL_AMT as REAL)*100,0) as 人口増加率
FROM
PREFECTURE PF
JOIN
(SELECT
PF_CODE,
TOTAL_AMT
FROM
POPU_TRANSITION
WHERE
SURVEY_YEAR = 2015) PO2015
ON
PF.PF_CODE = PO2015.PF_CODE
JOIN
(SELECT
PF_CODE,
TOTAL_AMT
FROM
POPU_TRANSITION
WHERE
SURVEY_YEAR = 2020) PO2020
ON
PF.PF_CODE = PO2020.PF_CODE
WHERE
PO2015.TOTAL_AMT < PO2020.TOTAL_AMT
ORDER BY
人口増加率 DESC,
PF.PF_CODE asc