select itemid from trade where behaviortype=3 and count(itemid)>100
select itemid from trade where behaviortype=3 and max(itemid)>100
select itemid from trade where behaviortype=3 and having count(itemid)>100 group by itemid
select itemid from trade where behaviortype=3 group by itemidHaving count(itemid)>100