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 names of the wrestlers who have more than 1 reign?
assistant
SELECT name FROM wrestler WHERE reign > 1;
human
More than 50 days held instead.
assistant
SELECT name FROM wrestler WHERE Days_held > 50;
human
Give the times of elimination only.
assistant
SELECT T1.Time FROM elimination AS T1 JOIN wrestler AS T2 ON T1.Wrestler_ID = T2.Wrestler_ID WHERE T2.Days_held > 50 ;