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';
human
And what was the time duration in this case?
assistant
SELECT Time FROM Elimination WHERE Eliminated_By = 'Benjamin' AND team = 'Team Batista';
human
Show me the teams that have wrestlers eliminated by 'Punk'.
assistant
SELECT Team FROM Elimination WHERE Eliminated_By = 'Punk';
human
Hmmm. And what was the elimination move used?
assistant
SELECT Elimination_Move FROM Elimination WHERE Eliminated_By = "Punk" ;