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