Database: wrestler

CREATE TABLE "wrestler" (
"Wrestler_ID" int,
"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")
);

Question: How many wrestlers are there?
SQL: SELECT count(*) FROM wrestler

Question: Count the number of wrestlers.
SQL: SELECT count(*) FROM wrestler

Question: List the names of wrestlers in descending order of days held.
SQL: SELECT Name FROM wrestler ORDER BY Days_held DESC

Question: What are the names of the wrestlers, ordered descending by days held?
SQL: SELECT Name FROM wrestler ORDER BY Days_held DESC

Question: What is the name of the wrestler with the fewest days held?
SQL: SELECT Name FROM wrestler ORDER BY Days_held ASC LIMIT 1

Question: Return the name of the wrestler who had the lowest number of days held.
SQL: SELECT Name FROM wrestler ORDER BY Days_held ASC LIMIT 1

Question: What are the distinct reigns of wrestlers whose location is not "Tokyo,Japan" ?
SQL: SELECT DISTINCT Reign FROM wrestler WHERE LOCATION != "Tokyo , Japan"

Question: Give the different reigns of wrestlers who are not located in Tokyo, Japan.
SQL: SELECT DISTINCT Reign FROM wrestler WHERE LOCATION != "Tokyo , Japan"

Question: What are the names and location of the wrestlers?
SQL: SELECT Name ,  LOCATION FROM wrestler

Question: Give the names and locations of all wrestlers.
SQL: SELECT Name ,  LOCATION FROM wrestler

Question: What are the elimination moves of wrestlers whose team is "Team Orton"?
SQL: SELECT Elimination_Move FROM Elimination WHERE Team  =  "Team Orton"

Question: Return the elimination movies of wrestlers on Team Orton.
SQL: SELECT Elimination_Move FROM Elimination WHERE Team  =  "Team Orton"

Question: What are the names of wrestlers and the elimination moves?
SQL: SELECT T2.Name ,  T1.Elimination_Move FROM elimination AS T1 JOIN wrestler AS T2 ON T1.Wrestler_ID  =  T2.Wrestler_ID

Question: Give the names of wrestlers and their elimination moves.
SQL: SELECT T2.Name ,  T1.Elimination_Move FROM elimination AS T1 JOIN wrestler AS T2 ON T1.Wrestler_ID  =  T2.Wrestler_ID

Question: List the names of wrestlers and the teams in elimination in descending order of days held.
SQL: 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

Question: What are the names of wrestlers and their teams in elimination, ordered descending by days held?
SQL: 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

Question: List the time of elimination of the wrestlers with largest days held.
SQL: SELECT T1.Time FROM elimination AS T1 JOIN wrestler AS T2 ON T1.Wrestler_ID  =  T2.Wrestler_ID ORDER BY T2.Days_held DESC LIMIT 1

Question: What is the time of elimination for the wrestler with the most days held?
SQL: SELECT T1.Time FROM elimination AS T1 JOIN wrestler AS T2 ON T1.Wrestler_ID  =  T2.Wrestler_ID ORDER BY T2.Days_held DESC LIMIT 1

Question: Show times of elimination of wrestlers with days held more than 50.
SQL: SELECT T1.Time FROM elimination AS T1 JOIN wrestler AS T2 ON T1.Wrestler_ID  =  T2.Wrestler_ID WHERE T2.Days_held  >  50

Question: What are the times of elimination for wrestlers with over 50 days held?
SQL: SELECT T1.Time FROM elimination AS T1 JOIN wrestler AS T2 ON T1.Wrestler_ID  =  T2.Wrestler_ID WHERE T2.Days_held  >  50

Question: Show different teams in eliminations and the number of eliminations from each team.
SQL: SELECT Team ,  COUNT(*) FROM elimination GROUP BY Team

Question: How many eliminations did each team have?
SQL: SELECT Team ,  COUNT(*) FROM elimination GROUP BY Team

Question: Show teams that have suffered more than three eliminations.
SQL: SELECT Team FROM elimination GROUP BY Team HAVING COUNT(*)  >  3

Question: Which teams had more than 3 eliminations?
SQL: SELECT Team FROM elimination GROUP BY Team HAVING COUNT(*)  >  3

Question: Show the reign and days held of wrestlers.
SQL: SELECT Reign ,  Days_held FROM wrestler

Question: What are the reigns and days held of all wrestlers?
SQL: SELECT Reign ,  Days_held FROM wrestler

Question: What are the names of wrestlers days held less than 100?
SQL: SELECT Name FROM wrestler WHERE Days_held  <  100

Question: Return the names of wrestlers with fewer than 100 days held.
SQL: SELECT Name FROM wrestler WHERE Days_held  <  100

Question: Please show the most common reigns of wrestlers.
SQL: SELECT Reign FROM wrestler GROUP BY Reign ORDER BY COUNT(*) DESC LIMIT 1

Question: Which reign is the most common among wrestlers?
SQL: SELECT Reign FROM wrestler GROUP BY Reign ORDER BY COUNT(*) DESC LIMIT 1

Question: List the locations that are shared by more than two wrestlers.
SQL: SELECT LOCATION FROM wrestler GROUP BY LOCATION HAVING COUNT(*)  >  2

Question: Which locations are shared by more than two wrestlers?
SQL: SELECT LOCATION FROM wrestler GROUP BY LOCATION HAVING COUNT(*)  >  2

Question: List the names of wrestlers that have not been eliminated.
SQL: SELECT Name FROM wrestler WHERE Wrestler_ID NOT IN (SELECT Wrestler_ID FROM elimination)

Question: What are the names of wrestlers who have never been eliminated?
SQL: SELECT Name FROM wrestler WHERE Wrestler_ID NOT IN (SELECT Wrestler_ID FROM elimination)

Question: Show the teams that have both wrestlers eliminated by "Orton" and wrestlers eliminated by "Benjamin".
SQL: SELECT Team FROM Elimination WHERE Eliminated_By  =  "Orton" INTERSECT SELECT Team FROM Elimination WHERE Eliminated_By  =  "Benjamin"

Question: What are the teams that have both wrestlers eliminated by Orton and wrestlers eliminated by Benjamin?
SQL: SELECT Team FROM Elimination WHERE Eliminated_By  =  "Orton" INTERSECT SELECT Team FROM Elimination WHERE Eliminated_By  =  "Benjamin"

Question: What is the number of distinct teams that suffer elimination?
SQL: SELECT COUNT (DISTINCT team) FROM elimination

Question: How many different teams have had eliminated wrestlers?
SQL: SELECT COUNT (DISTINCT team) FROM elimination

Question: Show the times of elimination by "Punk" or "Orton".
SQL: SELECT TIME FROM elimination WHERE Eliminated_By  =  "Punk" OR Eliminated_By  =  "Orton"

Question: What are the times of elimination for any instances in which the elimination was done by Punk or Orton?
SQL: SELECT TIME FROM elimination WHERE Eliminated_By  =  "Punk" OR Eliminated_By  =  "Orton"