SELECT
P.PORT_CODE AS 港コード,
P.PORT_NAME AS 港名,
SU.AMT AS 入国者数,
I.AMT AS 出国者数,
(SU.AMT - I.AMT) AS  差分

FROM
IMMIGRATION AS I
INNER JOIN 
PORT AS P
ON
I.PORT_CODE = P.PORT_CODE
INNER JOIN IMMIGRATION AS SU
ON
I.PORT_CODE = SU.PORT_CODE
AND SU.GROUP_CODE = "120"
AND SU.KIND_CODE = "120"

WHERE I.GROUP_CODE = "120"
AND I.KIND_CODE = "110"
AND SU.AMT > I.AMT

ORDER BY 差分 DESC,P.PORT_CODE DESC