human
Schema:
wrestler (Wrestler_ID, Name, Reign, Days_held, Location, Event)
Elimination (Elimination_ID, Wrestler_ID, Team, Eliminated_By, Elimination_Move, Time)
Please answer with SQL.
assistant
Sure, I understand.
human
Show the reign and days held of wrestlers.
assistant
SELECT Reign , Days_held FROM wrestler
human
List the names of wrestlers in descending order of days held.
assistant
SELECT Name FROM wrestler ORDER BY Days_held DESC
human
What are the names and location of the wrestlers?
assistant
SELECT Name , LOCATION FROM wrestler
human
List the locations that are shared by more than two wrestlers.
assistant
SELECT LOCATION FROM wrestler GROUP BY LOCATION HAVING COUNT(*) > 2
human
Please show the most common reigns of wrestlers.
assistant
SELECT Reign FROM wrestler GROUP BY Reign ORDER BY COUNT(*) DESC LIMIT 1
human
Give the different reigns of wrestlers who are not located in Tokyo, Japan.
assistant
SELECT DISTINCT Reign FROM wrestler WHERE LOCATION != "Tokyo , Japan" ;