select
p.PORT_CODE as "港コード",
PORT_NAME as "港名",
i110.AMT as "入国者数",
i120.AMT as "出国者数",
i110.AMT - i120.AMT as "差分"
from PORT as p
join IMMIGRATION as i110 on p.PORT_CODE = i110.PORT_CODE and i110.KIND_CODE = 110 and i110.GROUP_CODE = 120
join IMMIGRATION as i120 on p.PORT_CODE = i120.PORT_CODE and i120.KIND_CODE = 120 and i120.GROUP_CODE = 120
where i110.AMT > i120.AMT
order by i110.AMT - i120.AMT desc, p.PORT_CODE desc