SELECT
    PR.PF_CODE AS 都道府県コード,
    PR.PF_NAME AS 都道府県名,
    PO_2015.TOTAL_AMT AS 総人口2015年,
    PO_2020.TOTAL_AMT AS 総人口2020年,
    ROUND(100.0 * PO_2020.TOTAL_AMT / PO_2015.TOTAL_AMT) AS 人口増加率
FROM PREFECTURE AS PR
    INNER JOIN POPU_TRANSITION AS PO_2015
        ON PR.PF_CODE = PO_2015.PF_CODE
    INNER JOIN POPU_TRANSITION AS PO_2020
        ON PR.PF_CODE = PO_2020.PF_CODE
WHERE
    PO_2015.SURVEY_YEAR = 2015
    AND
    PO_2020.SURVEY_YEAR = 2020
    AND
    人口増加率 > 100.0
ORDER BY
    人口増加率 DESC,
    都道府県コード ASC
;