SELECT
    pref.PF_CODE AS '都道府県コード',
    pref.PF_NAME AS '都道府県名',
    TOTAL_AMT_2015 AS '総人口2015年',
    TOTAL_AMT_2020 AS '総人口2020年',
    ROUND(TOTAL_AMT_2020*100.0/TOTAL_AMT_2015, 0) '人口増加率'
FROM 
    PREFECTURE AS pref
    INNER JOIN (
        SELECT SURVEY_YEAR, PF_CODE, TOTAL_AMT AS TOTAL_AMT_2015
        FROM POPU_TRANSITION
        WHERE SURVEY_YEAR = 2015
        ) AS popu_2015
    ON pref.PF_CODE = popu_2015.PF_CODE
    LEFT OUTER JOIN (
        SELECT SURVEY_YEAR, PF_CODE, TOTAL_AMT AS TOTAL_AMT_2020
        FROM POPU_TRANSITION
        WHERE SURVEY_YEAR = 2020
        ) AS popu_2020
    ON pref.PF_CODE = popu_2020.PF_CODE
WHERE 
    TOTAL_AMT_2015 < TOTAL_AMT_2020
ORDER BY
    人口増加率 DESC,
    pref.PF_CODE ASC;