select
I.PORT_CODE as "港コード"
, P.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 as I
inner join PORT as P on P.PORT_CODE = I.PORT_CODE
inner join GRP as G on G.GROUP_CODE = I.GROUP_CODE
where G.GROUP_NAME = '外国人'
group by I.PORT_CODE
having sum(case when KIND_CODE = 110 then AMT else 0 end) > sum(case when KIND_CODE = 120 then AMT else 0 end)
order by 5 desc, 1 desc