select po.port_code as 港コード
        , po.port_name as 港名
        , sum(case when im.kind_code = 110 then im.kind_code else 0 end) as 入国者数
        , sum(case when im.kind_code = 120 then im.kind_code else 0 end) as 出国者数
        from immigration as im
	 inner join port as po
		    on im.port_code = po.port_code
	 inner join grp
		    on im.group_code = grp.group_code
 where grp.group_code = 120
 order by po.port_code