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
Which wrestler has the largest reign?
assistant
SELECT name FROM wrestler ORDER BY Reign DESC LIMIT 1;
human
Largest days held instead.
assistant
SELECT name FROM wrestler ORDER BY Days_held DESC LIMIT 1;
human
List the elimination move of this, not the name.
assistant
SELECT T1.Elimination_Move FROM elimination AS T1 JOIN wrestler AS T2 ON T1.Wrestler_ID = T2.Wrestler_ID ORDER BY Days_held DESC LIMIT 1 ;