with tab_1 as (
select
    port_code
    , sum(case when group_code = 120 and kind_code = 110 then amt else 0 end) as 入国者数
    , sum(case when group_code = 120 and kind_code = 120 then amt else 0 end) as 出国者数
from
    immigration
group by
    port_code
)
select
    t1.port_code as 港コード
    , port_name as 港名
    , 入国者数
    , 出国者数
    , 入国者数 - 出国者数 as 差分
from
    tab_1 t1
left join
    port t2
on
    t1.port_code = t2.port_code
where
    入国者数 > 出国者数
order by
    差分 desc
    , t1.port_code desc