Which wrestler has the largest reign?
select name from wrestler order by reign desc limit 1
Largest days held instead.
select name from wrestler order by days_held desc limit 1
List the elimination move of this, not the name.
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
List the elimination time instead.
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