WITH IMM AS(
    SELECT
        PORT_CODE,
        SUM(CASE
            WHEN KIND_CODE = 110
            THEN AMT
            ELSE 0
            END) AS C_110,
        SUM(CASE
            WHEN KIND_CODE = 120
            THEN AMT
            ELSE 0
            END) AS C_120
    FROM
        IMMIGRATION
    GROUP BY
        PORT_CODE
)
SELECT
    t1.PORT_CODE AS 港コード,
    t2.PORT_NAME AS 港名,
    t1.C_110 AS 入国者数,
    T1.C_120 AS 出国者数,
    t1.C_110 - t1.C_120 AS 差分
FROM
    IMM AS t1
INNER JOIN PORT AS t2
    ON t1.PORT_CODE = t2.PORT_CODE
ORDER BY
    5 DESC,
    1
;