with 人口増加率 as (
    select
        P.pf_code,
        P.pf_name,
        PT2015.total_amt as total_amount_2015,
        PT2020.total_amt as total_amount_2020,
        round(100.0 * PT2020.total_amt / PT2015.total_amt) as growth_rate
    from
        prefecture P
        inner join popu_transition PT2015
        on PT2015.pf_code = P.pf_code and PT2015.survey_year = 2015
        inner join popu_transition PT2020
        on PT2020.pf_code = P.pf_code and PT2020.survey_year = 2020
)
select
    pf_code as '都道府県コード',
    pf_name as '都道府県名',
    total_amount_2015 as '総人口2015年',
    total_amount_2020 as '総人口2020年',
    growth_rate as '人口増加率'
from
    人口増加率
where
    total_amount_2020 > total_amount_2015
order by
    growth_rate desc, pf_code
;