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,
        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
) USING (PORT_CODE)
INNER JOIN (
    SELECT
        PORT_CODE,
        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
) USING (PORT_CODE)
ORDER BY
    AMT_1 - AMT_2 DESC,
    PORT_CODE DESC