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