SELECT PO.PF_CODE as 都道府県コード, PF.PF_NAME as 都道府県名, PO.TOTAL_AMT as 総人口2015年, PO_2020.TOTAL_AMT as 総人口2020年, ROUND(CAST(PO_2020.TOTAL_AMT AS REAL) / CAST(PO.TOTAL_AMT AS REAL) * 100, -1) as 人口増加率
FROM POPU_TRANSITION as PO
JOIN PREFECTURE as PF
ON PO.PF_CODE = PF.PF_CODE
JOIN POPU_TRANSITION as PO_2020
ON PF.PF_CODE = PO_2020.PF_CODE
AND PO_2020.SURVEY_YEAR = 2020
WHERE PO.SURVEY_YEAR = 2015
AND PO_2020.TOTAL_AMT >= PO.TOTAL_AMT
ORDER BY 人口増加率 DESC, 都道府県コード ASC;