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) AS "人口増加率"
FROM PREFECTURE A
INNER JOIN POPU_TRANSITION B
ON A.PF_CODE=B.PF_CODE AND B.SURVEY_YEAR=2015
INNER JOIN POPU_TRANSITION C
ON A.PF_CODE=C.PF_CODE AND C.SURVEY_YEAR=2020
WHERE B.TOTAL_AMT < C.TOTAL_AMT
order by 5 DESC,1 ASC