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 names of all the wrestlers?
assistant
SELECT Name FROM wrestler;
human
And what about teams in elimination?
assistant
SELECT Team FROM Elimination;
human
Can I see a list with wrestler names and teams in elimination in descending order based on days held?
assistant
SELECT T2.Name , T1.Team FROM elimination AS T1 JOIN wrestler AS T2 ON T1.Wrestler_ID = T2.Wrestler_ID ORDER BY T2.Days_held DESC ;