select 
    p.pf_code `都道府県コード`, 
    p.pf_name `都道府県名`, 
    (select total_amt from popu_transition pt where pt.pf_code = p.pf_code and survey_year=2015) `総人口2015年`, 
    (select total_amt from popu_transition pt where pt.pf_code = p.pf_code and survey_year=2020) `総人口2020年`,
    round((select total_amt from popu_transition pt where pt.pf_code = p.pf_code and survey_year=2020) * 100.0 / (select total_amt from popu_transition pt where pt.pf_code = p.pf_code and survey_year=2015)) `人口増加率`
from 
    Prefecture p 
where 
    `総人口2015年` is not null and `総人口2020年` is not null
    and  `人口増加率` >= 100
order by 
    `人口増加率` desc, `都道府県コード`