这个sql怎么实现 求详细sql语句

[解决办法]

area 表为a

select nvl(a.city,"未知") , count(reg_ip) from a 
  full join b 
on (b.reg_ip between a.begin_id and a.end_ip)
group by a.city