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