SELECT
    i.PORT_CODE as '港コード'
    ,p.port_name as '港名'
    ,sum(CASE WHEN i.kind_code IS '110' THEN i.AMT ELSE 0 END) as '入国者数'
    ,sum(CASE WHEN i.kind_code IS '120' THEN i.AMT ELSE 0 END) as '出国者数'
    ,sum(CASE WHEN i.kind_code IS '110' THEN i.AMT ELSE 0 END) - sum(CASE WHEN i.kind_code IS '120' THEN i.AMT ELSE 0 END) as '差分'
FROM IMMIGRATION i
INNER JOIN GRP g
    ON g.group_code = i.group_code
INNER jOIN PORT p
    ON p.port_code = i.port_code
WHERE 1 = 1
    and i.group_code IS '120'
group by
    i.port_code
HAVING
    sum(CASE WHEN i.kind_code IS '110' THEN i.AMT ELSE 0 END) > sum(CASE WHEN i.kind_code IS '120' THEN i.AMT ELSE 0 END)
ORDER BY
    sum(CASE WHEN i.kind_code IS '110' THEN i.AMT ELSE 0 END) - sum(CASE WHEN i.kind_code IS '120' THEN i.AMT ELSE 0 END) DESC
    ,i.port_code DESC