with popu_2015 as (
    select
        pf_code,
        total_amt as total_amt_2015
    from popu_transition where survey_year = 2015
),

popu_2020 as (
    select
        pf_code,
        total_amt as total_amt_2020
    from popu_transition where survey_year = 2020
)

select
    popu_2015.pf_code as "都道府県コード",
    prefecture.pf_name as "都道府県名",
    popu_2015.total_amt_2015 as "総人口2015年",
    popu_2020.total_amt_2020 as "総人口2020年",
    round(
        cast(popu_2020.total_amt_2020 as real) / popu_2015.total_amt_2015 * 100
    )
        as "人口増加率"
from popu_2015 inner join popu_2020
    on popu_2015.pf_code = popu_2020.pf_code
inner join prefecture on popu_2015.pf_code = prefecture.pf_code
where popu_2015.total_amt_2015 < popu_2020.total_amt_2020
order by "人口増加率" desc, "都道府県コード" asc;