SELECT 
    	 P.port_code AS '港コード'
    	,P.port_name AS '港名'
    	,SUM(
    		CASE I.kind_code
    			WHEN '110' THEN I.AMT
    		END
    	) AS '入国者数'
    	,SUM(
    		CASE I.kind_code
    			WHEN '120' THEN I.AMT
    		END
    	) AS '出国者数'
    	,SUM(
    		CASE I.kind_code
    			WHEN '110' THEN I.AMT
    			WHEN '120' THEN -1 * I.AMT
    		END
    	) '差分'
    FROM
    	Port P
    INNER JOIN
    	IMMIGRATION I	
    ON
    	P.port_code = I.port_code
    INNER JOIN
    	GRP G
    ON
    	G.group_code = I.group_code
    GROUP BY
    	P.port_code	
    HAVING
        差分 > 0
    ORDER BY
        差分 DESC 
       ,港コード DESC