SELECT
    p.pf_code as '都道府県コード',
    p.pf_name as '都道府県名',
    a.total_amt as '総人口2015年',
    b.total_amt as '総人口2020年',
    ROUND(100.0*b.total_amt/a.total_amt, 0) as '人口増加率'
FROM
    (prefecture p
    JOIN (SELECT pf_code, total_amt FROM POPU_TRANSITION WHERE survey_year = 2015) a
    ON a.pf_code = p.pf_code
    JOIN (SELECT pf_code, total_amt FROM POPU_TRANSITION WHERE survey_year = 2020) b
    ON b.pf_code = p.pf_code
    )
WHERE 
    a.total_amt < b.total_amt
ORDER BY
    人口増加率 DESC,
    都道府県コード