SELECT
    B.PF_CODE as 都道府県コード,
    A.PF_NAME as 都道府県名,
    B.TOTAL_AMT as 総人口2015年,
    C.TOTAL_AMT as 総人口2020年,
    ROUND(100.0 * C.TOTAL_AMT * 1.0 / B.TOTAL_AMT) as 人口増加率
FROM PREFECTURE as A
INNER JOIN POPU_TRANSITION as B
    ON A.PF_CODE = B.PF_CODE
INNER JOIN POPU_TRANSITION as C
    ON 
        B.SURVEY_YEAR = 2015
        AND
        C.SURVEY_YEAR = 2020
        AND
        B.PF_CODE = C.PF_CODE
        AND
        B.TOTAL_AMT < C.TOTAL_AMT
ORDER BY
    人口増加率 DESC,
    都道府県コード ASC
;