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 location that was share by more than two wrestler
assistant
SELECT LOCATION FROM wrestler GROUP BY LOCATION HAVING COUNT( * ) > 2;
human
which of them has the highest days held
assistant
SELECT LOCATION FROM wrestler GROUP BY LOCATION HAVING COUNT( * ) > 2 ORDER BY days_held DESC LIMIT 1 ;