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