WITH IMPORT as (
    SELECT
        PORT_CODE,
        AMT
    FROM
        IMMIGRATION AS IM
    WHERE
        GROUP_CODE = '120'
        and KIND_CODE = '110'
    GROUP BY
        PORT_CODE
),
EXPORT as (
    SELECT
        PORT_CODE,
        AMT
    FROM
        IMMIGRATION AS IM
    WHERE
        GROUP_CODE = '120'
        and KIND_CODE = '120'
    GROUP BY
        PORT_CODE
)
SELECT
    P.PORT_CODE as "港コード",
    P.PORT_NAME as "港名",
    I.AMT as "入国者数",
    E.AMT as "出国者数",
    (I.AMT - E.AMT) as "差分"
    FROM PORT as P
    INNER JOIN IMPORT as I on P.PORT_CODE = I.PORT_CODE
    INNER JOIN EXPORT as E on P.PORT_CODE = E.PORT_CODE
    WHERE I.AMT > E.AMT
    ORDER BY "差分" DESC, P.PORT_CODE DESC