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 the elimination time of wrestlers
assistant
SELECT Time FROM elimination;
human
What are the names of the wrestlers and their elimination times?
assistant
SELECT T1.Time , T2.name FROM elimination AS T1 JOIN wrestler AS T2 ON T1.Wrestler_ID = T2.Wrestler_ID;
human
What are the names of wresters and their elimination times whose days held is greater than 50?
assistant
SELECT T2.name , T1.Time FROM elimination AS T1 JOIN wrestler AS T2 ON T1.Wrestler_ID = T2.Wrestler_ID WHERE T2.Days_held > 50 ;