select IM1.PORT_CODE 港コード
,PORT_NAME 港名
,IM1.AMT 入国者数
,IM2.AMT 出国者数
,IM1.AMT - IM2.AMT 差分
from IMMIGRATION IM1 inner join PORT PT
on IM1.PORT_CODE=PT.PORT_CODE
inner join IMMIGRATION IM2
on IM1.PORT_CODE=IM2.PORT_CODE
and IM2.KIND_CODE ='120'
and IM2.GROUP_CODE='120'
where IM1.KIND_CODE ='110'
and IM1.GROUP_CODE='120'
and IM1.AMT - IM2.AMT>0
order by (IM1.AMT - IM2.AMT) desc ,IM1.PORT_CODE desc