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