SELECT
	P.PORT_CODE AS "コード",
	P.PORT_NAME AS "港名",
	I110.AMT AS "入国者数",
	I120.AMT AS "出国者数",
	I110.AMT - I120.AMT AS "差分"
FROM
	PORT P
	INNER JOIN
	IMMIGRATION I110
	ON
		P.PORT_CODE = I110.PORT_CODE
		AND I110.KIND_CODE='110'
	INNER JOIN
	IMMIGRATION I120
	ON
		P.PORT_CODE = I120.PORT_CODE
		AND I120.KIND_CODE='120'
WHERE
	I110.GROUP_CODE = ( SELECT GROUP_CODE FROM GRP WHERE GROUP_NAME='外国人')
	AND I110.GROUP_CODE = ( SELECT GROUP_CODE FROM GRP WHERE GROUP_NAME='外国人')
GROUP BY
	P.PORT_CODE,
	P.PORT_NAME
HAVING
	SUM(I110.AMT)>SUM(I120.AMT)
ORDER BY
	5 DESC, 1 DESC