What are the names of wrestlers and the elimination moves?
create table wrestler (name varchar, wrestler_id varchar, PRIMARY KEY (name)); create table elimination (elimination_move varchar, wrestler_id varchar, PRIMARY KEY (elimination_move))
select t2.name, t1.elimination_move from elimination as t1 join wrestler as t2 on t1.wrestler_id = t2.wrestler_id