Обсуждение: Where of an aggregate

HI!
Try this

select c.traffic from
(select sum(bytes) as traffic   from traffic_table
group by ip) c where c.traffic<(100*1024*1024);