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