SELECT
    PO.PF_CODE AS "都道府県コード",
    PF.PF_NAME AS "都道府県名",
    SUM(CASE WHEN PO.SURVEY_YEAR = 2015 THEN PO.TOTAL_AMT ELSE 0 END) AS "総人口2015年",
    SUM(CASE WHEN PO.SURVEY_YEAR = 2020 THEN PO.TOTAL_AMT ELSE 0 END) AS "総人口2020年",
    ROUND((SUM(CASE WHEN PO.SURVEY_YEAR = 2020 THEN PO.TOTAL_AMT ELSE 0 END) * 100.0 / SUM(CASE WHEN PO.SURVEY_YEAR = 2015 THEN PO.TOTAL_AMT ELSE 0 END)), 0) AS "人口増加率"
FROM
    POPU_TRANSITION AS PO
    INNER JOIN PREFECTURE AS PF ON PF.PF_CODE = PO.PF_CODE
WHERE
    PO.SURVEY_YEAR IN (2015, 2020)
GROUP BY
    PO.PF_CODE, PF.PF_NAME
HAVING
    SUM(CASE WHEN PO.SURVEY_YEAR = 2020 THEN PO.TOTAL_AMT ELSE 0 END) >= SUM(CASE WHEN PO.SURVEY_YEAR = 2015 THEN PO.TOTAL_AMT ELSE 0 END)
ORDER BY
    "人口増加率" DESC,
    "都道府県コード" ASC;