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年`,
     (select total_amt from popu_transition pt where pt.pf_code = p.pf_code and survey_year=2020) * 100 / (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
order by 
    `人口増加率` desc, `都道府県コード`