select pop.pf_code as 都道府県コード, pf.pf_name as 都道府県名,
    pop.total_amt as 総人口2015年,
    pop2.total_amt as 総人口2020年,
    round(cast(pop2.total_amt as real)/cast(pop.total_amt as real)*100,0) as 人口増加率
    from popu_transition as pop
left join prefecture as pf
    ON pop.pf_code = pf.pf_code
left join popu_transition as pop2
    ON pop.pf_code = pop2.pf_code
WHERE pop.survey_year = 2015
    and pop2.survey_year = 2020
order by 人口増加率 desc, pf.pf_code asc
;