
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
*/
Show the reign and days held of wrestlers.
SELECT Reign ,  Days_held FROM wrestler
[{'Reign': '1', 'Days_held': '344'}, {'Reign': '1', 'Days_held': '113'}, {'Reign': '1', 'Days_held': '1285'}, {'Reign': '1', 'Days_held': '960'}, {'Reign': '1', 'Days_held': '1'}, {'Reign': '1', 'Days_held': '99'}, {'Reign': '1', 'Days_held': '54'}, {'Reign': '1', 'Days_held': '183'}, {'Reign': '2', 'Days_held': '35'}, {'Reign': '1', 'Days_held': '56'}]