select
    PORT_NAME
    ,sum(AMT) AS '入国者数'
from 
    IMMIGRATION
inner join
    PORT
using(PORT_CODE)
inner join 
    GRP
using(GROUP_CODE)
where 
    KIND_CODE = 120 
and 
    GROUP_CODE = 120 
group by 
    PORT_CODE
;