select
    p0.pf_code as 都道府県コード, pf.pf_name as 都道府県名, p0.total_amt as 総人口2015年, po2020.total_amt as 総人口2020年, round( cast(po2020.total_amt as float) / cast(po2020.total_amt as float) * 100)  as 人口増加率 
from POPU_TRANSITION as p0 --p0を決定
inner join PREFECTURE as pf 
on pf.pf_code = p0.pf_code 
--
inner join POPU_TRANSITION as PO2020 --po2020を決定
on po2020.pf_code = p0.pf_code 
and po2020.survey_year = 2020 

where
    p0.survey_year = 2015 
    AND  po2020.total_amt >= p0.total_amt
    
order by
    人口増加率 desc
    , 都道府県コード asc;