human
Schema:
country (Country_id, Country_name, Capital, Official_native_language)
team (Team_id, Name)
match_season (Season, Player, Position, Country, Team, Draft_Pick_Number, Draft_Class, College)
player (Player_ID, Player, Years_Played, Total_WL, Singles_WL, Doubles_WL, Team)
Please answer with SQL.
assistant
Sure, I understand.
human
What are the number of the positions for each type?
assistant
SELECT POSITION , COUNT( * ) FROM match_season GROUP BY POSITION;
human
Among those, which one is the list popular one?
assistant
SELECT POSITION FROM match_season GROUP BY POSITION ORDER by COUNT( * ) ASC LIMIT 1;
human
How about the most popular one?
assistant
SELECT POSITION FROM match_season GROUP BY POSITION ORDER BY COUNT( * ) DESC LIMIT 1 ;