SELECT PF.PF_CODE AS 都道府県コード, PF.PF_NAME AS 都道府県名, PO15.TOTAL_AMT AS 総人口2015年, PO15.TOTAL_AMT AS 総人口2020年,
ROUND(PO20.TOTAL_AMT * 100.0 / PO15.TOTAL_AMT) AS 人口増加率
FROM PREFECTURE AS PF
JOIN (SELECT PF_CODE, TOTAL_AMT FROM POPU_TRANSITION AS PO WHERE SURVEY_YEAR = 2015) AS PO15 ON PF.PF_CODE = PO15.PF_CODE
JOIN (SELECT PF_CODE, TOTAL_AMT FROM POPU_TRANSITION AS PO WHERE SURVEY_YEAR = 2020) AS PO20 ON PF.PF_CODE = PO20.PF_CODE
WHERE PO15.TOTAL_AMT < PO20.TOTAL_AMT
ORDER BY 人口増加率 DESC, 都道府県コード ASC