SELECT
    I.PORT_CODE AS 港コード
    , P.PORT_NAME AS 港名
    , SUM(
        CASE
            WHEN
                KIND_CODE = '110'
                THEN
                    I.AMT
                ELSE
                    0
        END
    ) AS 入国者数
    , SUM(
        CASE
            WHEN
                KIND_CODE = '120'
                THEN
                    I.AMT
                ELSE
                    0
        END
    ) AS 出国者数
    , SUM(
        CASE
            WHEN
                KIND_CODE = '110'
                THEN
                    I.AMT
                ELSE
                    0
        END
    ) - SUM(
        CASE
            WHEN
                KIND_CODE = '120'
                THEN
                    I.AMT
                ELSE
                    0
        END
    ) AS 差分
FROM
    IMMIGRATION AS I
LEFT OUTER JOIN
    PORT AS P
    ON 1=1
    AND I.PORT_CODE = P.PORT_CODE
WHERE
    1=1
    AND I.GROUP_CODE IN ('120', '130')
GROUP BY
    I.PORT_CODE
ORDER BY
    差分 DESC
    , I.PORT_CODE DESC