select TOTAL_AMT as "総人口2015年"
from POPU_TRANSITION
where survey year = 2015

select TOTAL_AMT as "総人口2020年"
from POPU_TRANSITION
where survey year = 2020

select p.PF_CODE as "都道府県コード", p.PF_NAME as "都道府県名",
       "総人口2015年", "総人口2020年", 
       ROUND("総人口2020年"/"総人口2015年"*100, 1) as "人口増加率"
from PREFECTURE p
join POPU_TRANSITION t
on p.PF_CODE = t.PF_CODE