human
Schema:
College (cName, state, enr)
Player (pID, pName, yCard, HS)
Tryout (pID, cName, pPos, decision)
Please answer with SQL.
assistant
Sure, I understand.
human
What information do you have for each position?
assistant
SELECT * FROM tryout GROUP BY pPos;
human
How many players tried out for each position?
assistant
SELECT pPos , COUNT( * ) FROM tryout GROUP BY pPos;
human
What was the most popular one?
assistant
SELECT pPos FROM tryout GROUP BY pPos ORDER BY COUNT( * ) DESC LIMIT 1 ;