select
    p.port_code 港コード, 
    p.port_name 港名,
    sum(case when i.kind_code = '110' then i.amt else 0 end) 入国者数,
    sum(case when i.kind_code = '120' then i.amt else 0 end) 出国者数,
    sum(case when i.kind_code = '110' then i.amt else 0 end)
    -
    sum(case when i.kind_code = '120' then i.amt else 0 end) 差分
from IMMIGRATION i
join PORT p on i.port_code = p.port_code
where 1 = 1
and i.group_code = '120'
group by p.port_code, p.port_name
having 
    sum(case when i.kind_code = '110' then i.amt else 0 end)
    >
    sum(case when i.kind_code = '120' then i.amt else 0 end)
order by 差分 desc, 港コード desc
;