with im as (
select * from immigration
where kind_code = '110' and group_code = 120
)
, ex as (
select * from immigration
where kind_code = '120' and group_code = 120
)
select im.port_code as '港コード', port.port_name as '港名', im.amt as '入国者数', ex.amt as '出国者数', im.amt - ex.amt as '差分'
from im join ex on im.port_code = ex.port_code
join port on im.port_code = port.port_code
where im.amt > ex.amt
order by (im.amt - ex.amt) desc, im.port_code desc