select pt1.PF_CODE AS "都道府県コード",
       PF_NAME AS "都道府県名",
       pt1.total_amt as "総人口2015年",
       pt2.total_amt as "総人口2020年",
       ROUND(cast(pt2.total_amt as FLOAT) / cast(pt1.total_amt as float) * 100,0) as "人口増加率"
FROM popu_transition as pt1
left join popu_transition as pt2 on pt1.pf_code = pt2.pf_code and pt2.survey_year = 2020
left join PREFECTURE as p on pt1.pf_code = p.pf_code
where pt1.survey_year = 2015 and pt2.total_amt > pt1.total_amt
ORDER BY 5 desc,1