What are the teams in elimination?
select team from elimination
Show the respective names of the wrestlers.
select t2.name, t1.team from elimination as t1 join wrestler as t2 on t1.wrestler_id = t2.wrestler_id
Order this by increasing time.
select t2.name, t1.team from elimination as t1 join wrestler as t2 on t1.wrestler_id = t2.wrestler_id order by t1.time asc
Decreasing instead.
select t2.name, t1.team from elimination as t1 join wrestler as t2 on t1.wrestler_id = t2.wrestler_id order by t1.time desc
Sort by days held in the same order.
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