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
Give the teams that have wrestlers eliminated by the move 'Go To Sleep'
assistant
SELECT Team FROM Elimination WHERE Elimination_Move = 'Go To Sleep';
human
How about the ones eliminated by 'Orton'
assistant
SELECT Team FROM Elimination WHERE Eliminated_By = 'Orton';
human
Give the ones that were also eliminated by 'Benjamin
assistant
SELECT Team FROM Elimination WHERE Eliminated_By = "Orton" INTERSECT SELECT Team FROM Elimination WHERE Eliminated_By = "Benjamin" ;