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