select A.PF_CODE as 都道府県コード,A.PF_NAME as 都道府県名,B.TOTAL_AMT as 総人口2015年,C.TOTAL_AMT as 総人口2020年,round(cast(C.TOTAL_AMT as real) / cast(B.TOTAL_AMT as real) * 100.0,0) as 人口増加率
from PREFECTURE A,POPU_TRANSITION B,POPU_TRANSITION C
WHERE A.PF_CODE = B.PF_CODE and B.PF_CODE = C.PF_CODE and B.SURVEY_YEAR = 2015 and C.SURVEY_YEAR = 2020
order by 人口増加率 desc,A.PF_CODE