Database: wrestler
Question: List the names of wrestlers and the teams in elimination in descending order of days held.
SQL:
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