SELECT
I.PORT_CODE AS 港コード,
P.PORT_NAME AS 港名,
SUM(CASE WHEN KIND_CODE = '110' THEN AMT ELSE 0 END) AS 入国者数,
SUM(CASE WHEN KIND_CODE = '120' THEN AMT ELSE 0 END) AS 出国者数,
SUM(CASE WHEN KIND_CODE = '110' THEN AMT ELSE 0 END) - SUM(CASE WHEN KIND_CODE = '120' THEN AMT ELSE 0 END) AS 差分
FROM IMMIGRATION I
INNER JOIN PORT P
ON I.PORT_CODE = P.PORT_CODE
WHERE I.GROUP_CODE = '120'
GROUP BY I.PORT_CODE
ORDER BY 差分 DESC, I.PORT_CODE DESC