SELECT
    p.PORT_CODE AS "港コード",
    p.PORT_NAME AS "港名",
    entry.AMT AS "入国者数",
    exit.AMT AS "出国者数",
    entry.AMT - exit.AMT AS "差分"
FROM
    IMMIGRATION AS i
    JOIN PORT AS p ON p.PORT_CODE = i.PORT_CODE
    JOIN GRP AS g ON g.GROUP_CODE = i.GROUP_CODE
    JOIN (SELECT PORT_CODE, AMT FROM IMMIGRATION WHERE KIND_CODE = 110) AS entry ON entry.PORT_CODE = i.PORT_CODE
    JOIN (SELECT PORT_CODE, AMT FROM IMMIGRATION WHERE KIND_CODE = 120) AS exit ON exit.PORT_CODE = i.PORT_CODE
WHERE
    g.GROUP_NAME = "外国人"
    AND (entry.AMT - exit.AMT) > 0
GROUP BY
    p.PORT_CODE
ORDER BY
    "差分" DESC,
    "港コード" DESC