select
    p_15.pf_code as '都道府県コード',
    pf_name as '都道府県名',
    p_15.total_amt as '総人口2015年',
    p_20.total_amt as '総人口2020年',
    round(
        cast(p_20.total_amt as real) * 100 / cast(p_15.total_amt as real)
    ) as '人口増加率'
from
    (
        select
            total_amt,
            po.pf_code
        from
            popu_transition po
        where
            po.survey_year = '2015'
    ) as p_15
    join (
        select
            total_amt,
            po.pf_code
        from
            popu_transition po
        where
            po.survey_year = '2020'
    ) as p_20 on p_15.pf_code = p_20.pf_code
    join prefecture pr on p_15.pf_code = pr.pf_code
where
    p_15.total_amt < p_20.total_amt
order by
    人口増加率 desc,
    p_15.pf_code asc