SELECT
    PREFECTURE.PF_CODE AS 都道府県コード,
    PREFECTURE.PF_NAME AS 都道府県名,
    X.TOTAL_AMT AS 総人口2015年,
    Y.TOTAL_AMT AS 総人口2020年,
    ROUND(1.0 * Y.TOTAL_AMT * 100 / (1.0 * X.TOTAL_AMT)) AS 人口増加率
FROM PREFECTURE,POPU_TRANSITION AS X,POPU_TRANSITION AS Y
WHERE
    PREFECTURE.PF_CODE = X.PF_CODE AND
    PREFECTURE.PF_CODE = Y.PF_CODE AND
    X.SURVEY_YEAR = 2015 AND
    Y.SURVEY_YEAR = 2020 AND
    X.TOTAL_AMT < Y.TOTAL_AMT
ORDER BY 人口増加率 DESC,PREFECTURE.PF_CODE ASC;