text: CREATE TABLE elimination (Team VARCHAR) -- Show different teams in eliminations and the number of eliminations from each team. SELECT Team, COUNT(*) FROM elimination GROUP BY Team CREATE TABLE elimination (Team VARCHAR) -- Show teams that have suffered more than three eliminations. SELECT Team FROM elimination GROUP BY Team HAVING COUNT(*) > 3 CREATE TABLE wrestler (Reign VARCHAR, Days_held VARCHAR) -- Show the reign and days held of wrestlers. SELECT Reign, Days_held FROM wrestler CREATE TABLE wrestler (Name VARCHAR, Days_held INTEGER) -- What are the names of wrestlers days held less than 100? SELECT Name FROM wrestler WHERE Days_held < 100 CREATE TABLE wrestler (Reign VARCHAR) -- Please show the most common reigns of wrestlers. SELECT Reign FROM wrestler GROUP BY Reign ORDER BY COUNT(*) DESC LIMIT 1 CREATE TABLE wrestler (LOCATION VARCHAR) -- List the locations that are shared by more than two wrestlers. SELECT LOCATION FROM wrestler GROUP BY LOCATION HAVING COUNT(*) > 2 CREATE TABLE elimination (Name VARCHAR, Wrestler_ID VARCHAR); CREATE TABLE wrestler (Name VARCHAR, Wrestler_ID VARCHAR) -- List the names of wrestlers that have not been eliminated. SELECT Name FROM wrestler WHERE NOT Wrestler_ID IN (SELECT Wrestler_ID FROM elimination) CREATE TABLE Elimination (Team VARCHAR, Eliminated_By VARCHAR) -- Show the teams that have both wrestlers eliminated by "Orton" and wrestlers eliminated by "Benjamin". SELECT Team FROM Elimination WHERE Eliminated_By = "Orton" INTERSECT SELECT Team FROM Elimination WHERE Eliminated_By = "Benjamin"