SELECT P.PF_CODE AS '都道府県コード', P.PF_NAME AS '都道府県名',s15.TOTAL_AMT AS '総人口2015年',
    s20.TOTAL_AMT AS '総人口2020年', ROUND(100.0 * s20.TOTAL_AMT / s15.TOTAL_AMT) AS '人口増加率'
    FROM PREFECTURE AS p
    INNER JOIN (SELECT PF_CODE, TOTAL_AMT FROM POPU_TRANSITION WHERE SURVEY_YEAR = 2015) AS s15 USING(PF_CODE)
    INNER JOIN (SELECT PF_CODE, TOTAL_AMT FROM POPU_TRANSITION WHERE SURVEY_YEAR = 2020) AS s20 USING(PF_CODE)
    WHERE s15.TOTAL_AMT < s20.TOTAL_AMT
    ORDER BY 5 DESC, 1;