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
What is the name of the wrestler with the fewest days held?
assistant
SELECT Name FROM wrestler ORDER BY Days_held ASC LIMIT 1
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 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
Show the reign and days held of wrestlers.
assistant
SELECT Reign , Days_held FROM wrestler
human
Which reign is the most common among wrestlers?
assistant
SELECT Reign FROM wrestler GROUP BY Reign ORDER BY COUNT( * ) DESC LIMIT 1 ;