select
    PORT_CODE as '港コード'
    ,PORT_NAME as '港名'
    ,sum(case when kind_code = "110" then amt else 0 end) as '入国者数'
    ,sum(case when kind_code = "120"then amt else 0 end) as '出国者数'
    ,sum(case when kind_code = "110" then amt else 0 end) - sum(case when kind_code = "120" then amt else 0 end) as '差分'
from
    immigration
    join port using(port_code)
where
    group_code = "120"
group by 1,2
having "入国者数" > "出国者数"
order by 5 desc,1 desc