WITH COUNT_AMT AS (
    SELECT 
        PORT_CODE
        ,KIND_CODE
        ,SUM(CASE WHEN KIND_CODE = 110 THEN AMT ELSE 0 END) AS "入国者数"
        ,SUM(CASE WHEN KIND_CODE = 120 THEN AMT ELSE 0 END) AS "出国者数"
    FROM IMMIGRATION
    WHERE GROUP_CODE = "120"
    GROUP BY PORT_CODE
)
SELECT
    COUNT_AMT.PORT_CODE AS "港コード"
    ,PORT.PORT_NAME AS "港名"
    ,COUNT_AMT."入国者数" AS "入国者数"
    ,COUNT_AMT."出国者数" AS "出国者数"
    ,COUNT_AMT."入国者数" - COUNT_AMT."出国者数" AS "差分"
FROM COUNT_AMT
INNER JOIN PORT ON COUNT_AMT.PORT_CODE = PORT.PORT_CODE
WHERE COUNT_AMT."入国者数" > COUNT_AMT."出国者数"
ORDER BY "差分" DESC, "港コード" DESC