with 人口増加率 as (
    select
        P.pf_code as '都道府県コード',
        P.pf_name as '都道府県名',
        PT2015.total_amt as '総人口2015年',
        PT2020.total_amt as '総人口2020年',
        round(100.0 * PT2020.total_amt / PT2015.total_amt) as '人口増加率'
    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
    *
from
    人口増加率
order by
    人口増加率 desc, 都道府県コード
;