select t3.PF_CODE as `都道府県コード`,t3.PF_NAME as ` 都道府県名`, t1.TOTAL_AMT as `総人口2015年`, t2.TOTAL_AMT as `総人口2020年`, round(cast(t2.TOTAL_AMT as REAL) / t1.TOTAL_AMT * 100) as `人口増加率`
from
(select SURVEY_YEAR, PF_CODE, TOTAL_AMT
from POPU_TRANSITION
where SURVEY_YEAR = 2015) t1 
left outer join
(select SURVEY_YEAR, PF_CODE, TOTAL_AMT
from POPU_TRANSITION
where SURVEY_YEAR = 2020) t2 on t1.PF_CODE = t2.PF_CODE
left outer join PREFECTURE t3 on t1.PF_CODE = t3.PF_CODE
where `人口増加率` > 100
order by `人口増加率` desc, `都道府県コード`