
CREATE TABLE "Elimination" (
	"Elimination_ID" TEXT, 
	"Wrestler_ID" TEXT, 
	"Team" TEXT, 
	"Eliminated_By" TEXT, 
	"Elimination_Move" TEXT, 
	"Time" TEXT, 
	PRIMARY KEY ("Elimination_ID"), 
	FOREIGN KEY("Wrestler_ID") REFERENCES wrestler ("Wrestler_ID")
)


CREATE TABLE wrestler (
	"Wrestler_ID" INTEGER, 
	"Name" TEXT, 
	"Reign" TEXT, 
	"Days_held" TEXT, 
	"Location" TEXT, 
	"Event" TEXT, 
	PRIMARY KEY ("Wrestler_ID")
)

CREATE TABLE "Elimination" (
	"Elimination_ID" TEXT, 
	"Wrestler_ID" TEXT, 
	"Team" TEXT, 
	"Eliminated_By" TEXT, 
	"Elimination_Move" TEXT, 
	"Time" TEXT, 
	PRIMARY KEY ("Elimination_ID"), 
	FOREIGN KEY("Wrestler_ID") REFERENCES wrestler ("Wrestler_ID")
)

/*
2 rows from Elimination table:
Elimination_ID	Wrestler_ID	Team	Eliminated_By	Elimination_Move	Time
1	1	Team Orton	Punk	Go To Sleep	00:11
2	2	Team Batista	Benjamin	Paydirt	07:38
*/


CREATE TABLE wrestler (
	"Wrestler_ID" INTEGER, 
	"Name" TEXT, 
	"Reign" TEXT, 
	"Days_held" TEXT, 
	"Location" TEXT, 
	"Event" TEXT, 
	PRIMARY KEY ("Wrestler_ID")
)

/*
2 rows from wrestler table:
Wrestler_ID	Name	Reign	Days_held	Location	Event
1	Rey Misterio Sr.	1	344	Tijuana , Mexico	Live event
2	Fishman	1	113	Tijuana , Mexico	Live event
*/
Give the names of wrestlers and their elimination moves.
SELECT T2.Name ,  T1.Elimination_Move FROM elimination AS T1 JOIN wrestler AS T2 ON T1.Wrestler_ID  =  T2.Wrestler_ID
[{'Name': 'Rey Misterio Sr.', 'Elimination_Move': 'Go To Sleep'}, {'Name': 'Fishman', 'Elimination_Move': 'Paydirt'}, {'Name': 'Gran Hamada', 'Elimination_Move': 'Rope hung DDT'}, {'Name': 'El Samurai', 'Elimination_Move': 'Silver Spoon DDT'}, {'Name': 'Último Dragón §', 'Elimination_Move': "World's Strongest Slam"}, {'Name': 'El Samurai §', 'Elimination_Move': 'Spear'}]