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
Show the teams that have wrestlers eliminated by 'Orton'.
assistant
SELECT Team FROM Elimination WHERE Eliminated_By = 'Orton';
human
Show me the teams that have wrestlers eliminated by 'Benjamin'.
assistant
SELECT Team FROM Elimination WHERE Eliminated_By = 'Benjamin';
human
What was the elimination move when the wrestlers in team Batista were eliminated by 'Benjamin'.
assistant
SELECT Elimination_Move FROM Elimination WHERE Eliminated_By = "Benjamin" AND team = "Team Batista" ;