CREATE TABLE elimination (elimination_id CLOB, wrestler_id CLOB, team CLOB, eliminated_by CLOB, elimination_move CLOB, time CLOB)
CREATE TABLE wrestler (wrestler_id NUMBER, name CLOB, reign CLOB, days_held CLOB, location CLOB, event CLOB)

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" "T1" JOIN "wrestler" "T2" ON "T1"."wrestler_id" = "T2"."wrestler_id" ORDER BY "T2"."days_held" DESC