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
Show the reigns of the wrestlers.
assistant
SELECT Reign FROM wrestler;
human
What is the least common reign?
assistant
SELECT Reign FROM wrestler GROUP BY Reign ORDER BY COUNT( * ) ASC LIMIT 1 ;