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
hi. can you tell me how many wrestlers were eliminated?
assistant
SELECT COUNT( * ) FROM Elimination;
human
can you list the elimination times of those with the largest days held? | Again, there can only be one with the largest days held, would you like that one? There are not multiple that can be 'largest' | yes, please
assistant
SELECT T1.Time FROM elimination AS T1 JOIN wrestler AS T2 ON T1.Wrestler_ID = T2.Wrestler_ID ORDER BY T2.Days_held DESC LIMIT 1 ;