with org as (
select
    a.port_code
    , case when a.kind_code=110 then a.amt else 0 end as _1
    , case when a.kind_code=120 then a.amt else 0 end as _2
from IMMIGRATION as a
-- inner join grp as b
    -- on a.group_code = b.group_code
where (a.group_code = 120 and a.kind_code = 110)
    or (a.group_code = 120 and a.kind_code = 120)
    --and (a.kind_code = 110 or a.kind_code = 120)
)
select
    a.port_code as '港コード'
    , b.port_name as '港名'
    , sum(a._1) '入国者数'
    , sum(a._2) '出国者数'
    , sum(a._1) - sum(a._2) as '差分'
from org as a
inner join port as b
    on a.port_code = b.port_code
group by a.port_code
order by 5 desc, 1 desc
;