select pr.PF_CODE as "都道府県コード", PF_NAME as "都道府県名", po15.TOTAL_AMT as "総人口2015年", po20.TOTAL_AMT as "総人口2020年", 100 + round(100.0 * (po20.TOTAL_AMT - po15.TOTAL_AMT) / po15.TOTAL_AMT) as "人口増加率" 
from PREFECTURE as pr 
join POPU_TRANSITION as po15 on pr.PF_CODE = po15.PF_CODE
join POPU_TRANSITION as po20 on pr.PF_CODE = po20.PF_CODE and po20.SURVEY_YEAR = 2020
where po15.TOTAL_AMT < po20.TOTAL_AMT and po15.SURVEY_YEAR = 2015
order by "人口増加率" desc, "都道府県コード" asc
;