SELECT pf.PF_CODE AS 都道府県コード,pf.PF_NAME AS 都道府県名,jugo.TOTAL_AMT AS 総人口2015年,
niju.TOTAL_AMT AS 総人口2020年,ROUND(cast(niju.TOTAL_AMT AS float)/cast(jugo.TOTAL_AMT AS float)*100) AS 人口増加率
FROM POPU_TRANSITION AS jugo
JOIN PREFECTURE AS pf ON pf.PF_CODE = jugo.PF_CODE
JOIN POPU_TRANSITION AS niju ON pf.PF_CODE = niju.PF_CODE AND niju.SURVEY_YEAR = 2020
WHERE jugo.SURVEY_YEAR = 2015
AND niju.TOTAL_AMT>jugo.TOTAL_AMT
ORDER BY 人口増加率 DESC,pf.PF_CODE ASC