SELECT
	II.PORT_CODE AS 港コード,
	P.PORT_NAME AS 港名,
	II.AMT AS 入国者数,
	IO.AMT AS 出国者数,
	II.AMT - IO.AMT AS 差分
FROM
	IMMIGRATION IO
	INNER JOIN IMMIGRATION II
	ON IO.PORT_CODE = II.PORT_CODE
	AND IO.GROUP_CODE = II.GROUP_CODE
	INNER JOIN PORT P
	ON II.PORT_CODE = P.PORT_CODE
	INNER JOIN GRP G
	ON IO.GROUP_CODE = G.GROUP_CODE
WHERE
	IO.KIND_CODE = '120'
AND II.KIND_CODE = '110'
AND G.GROUP_CODE = '120'
AND IO.AMT < II.AMT
ORDER BY
	差分 DESC,
	港コード DESC
;