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