select 
PO.PF_CODE as 都道府県コード,
PR.PF_NAME as 都道府県名,
PO.TOTAL_AMT as 総人口2020年,
PO_2015.TOTAL_AMT as 総人口2015年,
ROUND(cast(PO.TOTAL_AMT as real)/cast(PO_2015.TOTAL_AMT as real) * 100 ) as 人口増加率
from POPU_TRANSITION as PO 
join PREFECTURE as PR on PO.PF_CODE = PR.PF_CODE 
join POPU_TRANSITION as PO_2015 on PO_2015.PF_CODE = PR.PF_CODE and PO_2015.SURVEY_YEAR = 2015
where PO.SURVEY_YEAR = 2020
and PO.TOTAL_AMT >= PO_2015.TOTAL_AMT
order by 人口増加率 desc, PO.PF_CODE asc ;