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 names of the wrestlers.
assistant
SELECT Name FROM wrestler;
human
Who has been eliminated?
assistant
SELECT Name FROM wrestler WHERE Wrestler_ID IN ( SELECT Wrestler_ID FROM elimination );
human
Who hasn't been?
assistant
SELECT Name FROM wrestler WHERE Wrestler_ID NOT IN ( SELECT Wrestler_ID FROM elimination ) ;