select 
    pt.pf_code as "都道府県コード",
    pr.pf_name as "都道府県名",
    pt.total_amt_2015 as "総人口2015年",
    pt.total_amt_2020 as "総人口2020年",
    round(pt.total_amt_2020 * 100.0 / pt.total_amt_2015, 0) as "人口増加率"
from (
    select 
        pf_code,
        max(case when survey_year = 2015 then total_amt else 0 end) as total_amt_2015,
        max(case when survey_year = 2020 then total_amt else 0 end) as total_amt_2020
    from 
        popu_transition
    where 
        survey_year in (2015, 2020)
    group by 
        pf_code 
) pt 
left join 
    prefecture pr 
    on pt.pf_code = pr.pf_code 
where 
    pt.total_amt_2015 < pt.total_amt_2020
order by 
    "人口増加率" desc, 
    "都道府県コード" asc