SELECT
	a.PORT_CODE as 港コード,
	b.PORT_NAME as 港名,
	sum_AMT_110 as 入国者数,
	sum_AMT_120 as 出国者数,
	AMT_diff as 差分
FROM 
	(SELECT 
		d_110.PORT_CODE ,
		sum_AMT_110,
		sum_AMT_120,
		sum_AMT_110 - sum_AMT_120 as AMT_diff
	FROM 
		(SELECT PORT_CODE, sum(AMT) as sum_AMT_110 FROM IMMIGRATION WHERE KIND_CODE = "110" and GROUP_CODE = "120" GROUP BY PORT_CODE ) as d_110
	inner join 
		(SELECT PORT_CODE, sum(AMT) as sum_AMT_120 FROM IMMIGRATION WHERE KIND_CODE = "120" and GROUP_CODE = "120" GROUP BY PORT_CODE ) as d_120
	ON
		d_110.PORT_CODE = d_120.PORT_CODE
	WHERE
		sum_AMT_110 > sum_AMT_120
	) as a 
inner join
	PORT as b
ON
	a.PORT_CODE = b.PORT_CODE
ORDER BY 差分 DESC, 港コード DESC 
;