SELECT PT.PORT_CODE AS 港コード, PT.PORT_NAME AS 港名, IM110.AMT AS 入国者数, IM120.AMT AS 出国者数, (IM110.AMT - IM120.AMT) AS 差分 
FROM PORT AS PT
    INNER JOIN IMMIGRATION AS IM110 ON PT.PORT_CODE = IM110.PORT_CODE 
        AND IM110.GROUP_CODE = "120"
        AND IM110.KIND_CODE = "110"
    INNER JOIN IMMIGRATION AS IM120 ON PT.PORT_CODE = IM120.PORT_CODE 
        AND IM120.GROUP_CODE = "120"
        AND IM120.KIND_CODE = "120"
WHERE 差分 > 0  
ORDER BY 差分 DESC, 港コード DESC;