select 
    PO2015.PF_CODE as 都道府県コード,
    PO2015.PF_NAME as 都道府県名,
    PO2015.TOTAL_AMT as 総人口2015年,
    PO2020.TOTAL_AMT as 総人口2020年,
    round((cast(PO2020.TOTAL_AMT as real) / cast(PO2015.TOTAL_AMT as real))*100) as 人口増加率
from
    (select * from POPU_TRANSITION left join PREFECTURE on POPU_TRANSITION.PF_CODE = PREFECTURE.PF_CODE) as PO2015
left join 
    (select PF_CODE, TOTAL_AMT from POPU_TRANSITION where SURVEY_YEAR = 2020) as PO2020
on
    PO2015.PF_CODE = PO2020.PF_CODE
where
    PO2015.SURVEY_YEAR = 2015
order by
    人口増加率 desc,
    都道府県コード asc