select
PREFECTURE.PF_CODE as "都道府県コード",
PREFECTURE.PF_NAME as "都道府県名",
AMT15.TOTAL_AMT as "総人口2015年",
AMT20.TOTAL_AMT as "総人口2020年",
round(100*AMT20.TOTAL_AMT/cast(AMT15.TOTAL_AMT as REAL),0) as "人口増加率"
from
(select PF_CODE, TOTAL_AMT
from POPU_TRANSITION
where SURVEY_YEAR==2015) as AMT15,
(select PF_CODE, TOTAL_AMT
from POPU_TRANSITION
where SURVEY_YEAR==2020) as AMT20,
PREFECTURE
where
AMT15.PF_CODE==PREFECTURE.PF_CODE and 
AMT20.PF_CODE==PREFECTURE.PF_CODE and
AMT20.TOTAL_AMT>AMT15.TOTAL_AMT
order by "人口増加率" desc, PREFECTURE.PF_CODE asc