SELECT
     PT.PF_CODE AS '都道府県コード'
    ,P.PF_NAME AS '都道府県名'
    ,PT2015.TOTAL_AMT AS '総人口2015年'
    ,PT2020.TOTAL_AMT AS '総人口2020年'
    ,ROUND(PT2020.TOTAL_AMT*100.0 / PT2015.TOTAL_AMT, 0) AS '人口増加率'
FROM
(
    SELECT
        PF_CODE
    FROM
        POPU_TRANSITION
    GROUP BY
        PF_CODE
) AS PT

LEFT OUTER JOIN
(
    SELECT
        *
    FROM
        POPU_TRANSITION
    WHERE
        SURVEY_YEAR=2015
) AS PT2015
ON
    PT2015.PF_CODE = PT.PF_CODE

LEFT OUTER JOIN
(
    SELECT
        *
    FROM
        POPU_TRANSITION
    WHERE
        SURVEY_YEAR=2020
) AS PT2020
ON
    PT2020.PF_CODE = PT.PF_CODE

INNER JOIN
    PREFECTURE AS P
ON
    P.PF_CODE = PT.PF_CODE

WHERE
    PT2020.TOTAL_AMT > PT2015.TOTAL_AMT
    
ORDER BY
     ROUND(PT2020.TOTAL_AMT*100.0 / PT2015.TOTAL_AMT, 0) DESC
    ,PT.PF_CODE ASC