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