human
Schema:
wrestler (Wrestler_ID, Name, Reign, Days_held, Location, Event)
Elimination (Elimination_ID, Wrestler_ID, Team, Eliminated_By, Elimination_Move, Time)
Please answer with SQL.
assistant
Sure, I understand.
human
What are the teams who have suffered elimination?
assistant
SELECT Team FROM elimination;
human
Which ones have had only two eliminations?
assistant
SELECT Team FROM elimination GROUP BY Team HAVING COUNT( * ) = 2;
human
Which ones have had more than three?
assistant
SELECT Team FROM elimination GROUP BY Team HAVING COUNT( * ) > 3 ;