SELECT
    PORT_CODE AS '港コード',
    PORT_NAME AS '港名',
    AMT_1 AS '入国者数',
    AMT_2 AS '出国者数',
    AMT_1 - AMT_2 AS '差分'
FROM
    PORT
INNER JOIN (
    SELECT
        PORT_CODE,
        SUM(AMT) AS AMT_1
    FROM
        PORT
    INNER JOIN
        IMMIGRATION USING (PORT_CODE)
    INNER JOIN
        GRP USING (GROUP_CODE)
    WHERE
        GROUP_CODE = 120
        AND KIND_CODE = 110
    GROUP BY
        PORT_CODE
) USING (PORT_CODE)
INNER JOIN (
    SELECT
        PORT_CODE,
        SUM(AMT) AS AMT_2
    FROM
        PORT
    INNER JOIN
        IMMIGRATION USING (PORT_CODE)
    INNER JOIN
        GRP USING (GROUP_CODE)
    WHERE
        GROUP_CODE = 120
        AND KIND_CODE = 120
    GROUP BY
        PORT_CODE
) USING (PORT_CODE)
WHERE
    AMT_1 > AMT_2
ORDER BY
    AMT_1 - AMT_2 DESC,
    PORT_CODE DESC