with
    come as (
        select
            *
        from
            immigration
        where
            kind_code = 110
            and group_code = 120
    )
    ,go as (
        select
            *
        from
            immigration
        where
            kind_code = 120
            and group_code = 120
    )
    
select
    p.port_code as '港コード'
    ,p.port_name as '港名'
    ,come.amt as '入国者数'
    ,go.amt as '出国者数'
    ,come.amt - go.amt as '差分'
from
    come
join
    go
on
    come.port_code = go.port_code
    and come.amt > go.amt
join
    port p
on
    come.port_code = p.port_code
order by
    5 desc, 1 desc