SELECT
    i.PORT_CODE AS '港コード',
    PORT_NAME AS '港名',
    (SELECT
        SUM(AMT)
    FROM
        IMMIGRATION
    WHERE
        KIND_CODE = '110'
    GROUP BY
        GROUP_CODE
            ) AS '入国者数',
    (SELECT
        SUM(AMT)
    FROM
        IMMIGRATION
    WHERE
        KIND_CODE = '120'
    GROUP BY
        GROUP_CODE
            ) AS '出国者数',
    -- 入国者数 - 出国者数 AS '差分'
FROM
    IMMIGRATION AS i
INNER JOIN
    GRP AS g ON i.GROUP_CODE = g.GROUP_CODE
INNER JOIN
    PORT AS p ON i.PORT_CODE = p.PORT_CODE
ORDER BY
    -- 差分 desc,
    i.PORT_CODE DESC