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 times of elimination by 'Punk' or 'Orton'.
assistant
SELECT TIME FROM elimination WHERE Eliminated_By = 'Punk' OR Eliminated_By = 'Orton';
human
And by 'Benjamin'?
assistant
SELECT TIME FROM elimination WHERE Eliminated_By = 'Benjamin';
human
What was the average elimination time of all teams?
assistant
SELECT AVG ( TIME ) FROM elimination ;