SELECT T2.Name ,  T1.Team FROM elimination AS T1 JOIN wrestler AS T2 ON T1.Wrestler_ID  =  T2.Wrestler_ID ORDER BY T2.Days_held DESC
What are the names of wrestlers and their teams in elimination, ordered descending by days held?
SELECT T2.Name , T1.Team FROM elimination AS T1 JOIN wrestler AS T2 ON T1.Wrestler_ID = T2.Wrestler_ID ORDER BY T2.Days_held DESC
select t2 . name , t1 . team from elimination as t1 join wrestler as t2 on t1 . wrestler_id = t2 . wrestler_id order by t2 . days_held desc
What are the names of wrestlers and their teams in elimination , ordered descending by days held ?