with inner as (
	select PORT_CODE as inport
		,AMT as inamt
	from IMMIGRATION
	where GROUP_CODE = 120 and KIND_CODE = 110
)
,outer as (
	select PORT_CODE as outport
		,AMT as outamt
	from IMMIGRATION
	where GROUP_CODE = 120 and KIND_CODE = 120
)
select inport as 港コード
,PORT_NAME as 港名
,inamt as 入国者数
,outamt as 出国者数
,inamt - outamt as 差分
from inner
left outer join PORT on PORT.PORT_CODE=inport
left outer join outer on outport=inport
where 差分 >= 1
order by 差分 desc ,港コード desc