SELECT PO2015.PF_CODE AS 都道府県コード,
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) AS 人口増加率
FROM POPU_TRANSITION PO2015 INNER JOIN POPU_TRANSITION PO2020
ON PO2015.PF_CODE = PO2020.PF_CODE
AND PO2015.SURVEY_YEAR = 2015
AND PO2020.SURVEY_YEAR = 2020
LEFT JOIN PREFECTURE ON PO2015.PF_CODE = PREFECTURE.PF_CODE
WHERE PO2015.TOTAL_AMT < PO2020.TOTAL_AMT
ORDER BY 人口増加率 DESC, 都道府県コード ASC