SELECT
    t.pf_code as 都道府県コード,
    pf_name as 都道府県名,
    total2015 as 総人口2015年,
    total2020 as 総人口2020年,
    increment as 人口増加率
    FROM 
    (prefecture p JOIN (
        SELECT 
            a.pf_code as pf_code,
            a.total_amt as total2015,
            b.total_amt as total2020,
            ROUND(CAST(b.total_amt as FLOAT)/a.total_amt*100) as increment
        FROM
            popu_transition a,
            popu_transition b
        WHERE
            a.pf_code = b.pf_code
            AND a.survey_year = 2015
            AND b.survey_year = 2020
            AND a.total_amt < b.total_amt
     ) t ON p.pf_code = t.pf_code
     )
ORDER BY 人口増加率 DESC, 都道府県コード