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
Please show the most common reigns of wrestlers.
assistant
SELECT Reign FROM wrestler GROUP BY Reign ORDER BY COUNT(*) DESC LIMIT 1
human
What are the names of wrestlers days held less than 100?
assistant
SELECT Name FROM wrestler WHERE Days_held < 100
human
How many wrestlers are there?
assistant
SELECT count(*) FROM wrestler
human
What are the distinct reigns of wrestlers whose location is not 'Tokyo,Japan' ?
assistant
SELECT DISTINCT Reign FROM wrestler WHERE LOCATION != 'Tokyo , Japan'
human
What are the names and location of the wrestlers?
assistant
SELECT Name , LOCATION FROM wrestler
human
Which locations are shared by more than two wrestlers?
assistant
SELECT LOCATION FROM wrestler GROUP BY LOCATION HAVING COUNT( * ) > 2 ;