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 average number of days | did you mean the average days held by all wrestlers? | yes
assistant
SELECT AVG ( Days_held ) FROM wrestler;
human
what is the name of the wrestler with the fewest days held
assistant
SELECT name FROM wrestler ORDER by Days_held LIMIT 1;
human
what is the name of the first wrestler id | did you mean the name of the wrestler with id 1? | first wrestler
assistant
SELECT name FROM wrestler WHERE Wrestler_ID = 1 ;