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
List the locations that are shared by more than two wrestlers.
assistant
SELECT LOCATION FROM wrestler GROUP BY LOCATION HAVING COUNT(*) > 2
human
What are the names of wrestlers days held less than 100?
assistant
SELECT Name FROM wrestler WHERE Days_held < 100
human
List the time of elimination of the wrestlers with largest days held.
assistant
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
human
List the names of wrestlers and the teams in elimination in descending order of days held.
assistant
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
human
List the names of wrestlers in descending order of days held.
assistant
SELECT Name FROM wrestler ORDER BY Days_held DESC
human
Count the number of wrestlers.
assistant
SELECT COUNT( * ) FROM wrestler ;