What are names of all the wrestlers?
select name from wrestler
And what about teams in elimination?
select team from elimination
Can I see a list with wrestler names and teams in elimination in descending order based on 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