SELECT 
    PREFECTURE.PF_CODE AS "都道府県コード",
    PREFECTURE.PF_NAME AS "都道府県名",
    (
        SELECT
            TOTAL_AMT
        FROM
            POPU_TRANSITION
        WHERE
            SURVEY_YEAR = 2015
    )AS "総人口2015年",
    (
        SELECT
            TOTAL_AMT
        FROM
            POPU_TRANSITION
        WHERE
            SURVEY_YEAR = 2020
    )AS "総人口2020年"
FROM
    PREFECTURE
INNER JOIN
    POPU_TRANSITION
ON
    PREFECTURE.PF_CODE = POPU_TRANSITION.PF_CODE
GROUP BY
    都道府県コード,都道府県名
ORDER BY
    都道府県コード ASC