removing rows that meet certain aggregate criteria

[retsreg]

I have a database like this:

host | search term | number of searches
abc.com | "blah" | 5
def.com | "blah2" | 10

I want to eliminate rows containing any search term where the sum of
searches across all hosts is more than 200.

So for example, if the sum of searches for the keyword "blah" across
all hosts is 350, then I would want to eliminate all individual rows
containing the keyword "blah".

I'm new to SQL, so would welcome pointers on the fastest way to do this.

[Gord]

Off the top of my head, something like the following should do it if
your table was called [foo]:

DELETE * FROM foo
WHERE
search_term IN (
SELECT search_term FROM foo
GROUP BY search_term
HAVING (SUM(number_of_searches)>200)
)

[retsreg]

Thanks, I'll give this a try.