SELECT
    p.PF_CODE AS "都道府県コード",
    p.PF_NAME AS "都道府県名",
    (SELECT TOTAL_AMT FROM POPU_TRANSITION WHERE SURVEY_YEAR = "2015" AND PF_CODE = p.PF_CODE) AS "総人口2015年",
    (SELECT TOTAL_AMT FROM POPU_TRANSITION WHERE SURVEY_YEAR = "2020" AND PF_CODE = p.PF_CODE) AS "総人口2020年",
    ROUND(CAST((SELECT TOTAL_AMT FROM POPU_TRANSITION WHERE SURVEY_YEAR = "2020" AND PF_CODE = p.PF_CODE)AS FLOAT)/CAST((SELECT TOTAL_AMT FROM POPU_TRANSITION WHERE SURVEY_YEAR = "2015" AND PF_CODE = p.PF_CODE)AS FLOAT)*100)AS "人口増加率"
FROM
    PREFECTURE AS p
    JOIN POPU_TRANSITION AS pt ON p.PF_CODE = pt.PF_CODE
WHERE
    "人口増加率" > 100
GROUP BY
    p.PF_CODE
ORDER BY
    "人口増加率" DESC,
    "都道府県コード" ASC;