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