SELECT 
    pr.PF_CODE AS 都道府県コード, 
    PF_NAME AS 都道府県名, 
    pt15.TOTAL_AMT AS 総人口2015年, 
    pt20.TOTAL_AMT AS 総人口2020年, 
    ROUND(100. * pt20.TOTAL_AMT / pt15.TOTAL_AMT) AS 人口増加率 

FROM PREFECTURE AS pr 
    LEFT OUTER JOIN (
        SELECT * 
        FROM POPU_TRANSITION 
        WHERE SURVEY_YEAR = 2015 
    ) AS pt15 ON pr.PF_CODE = pt15.PF_CODE 

    LEFT OUTER JOIN (
        SELECT * 
        FROM POPU_TRANSITION 
        WHERE SURVEY_YEAR = 2020 
    ) AS pt20 ON pr.PF_CODE = pt20.PF_CODE 

WHERE 総人口2015年 < 総人口2020年 
ORDER BY 人口増加率 DESC, 都道府県コード 
;