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
Which position is the most popular among players in the tryout?
assistant
SELECT pPos FROM tryout GROUP BY pPos ORDER BY COUNT( * ) DESC LIMIT 1;
human
What were the names of the colleges for that position?
assistant
SELECT cName FROM tryout WHERE pPos = ( SELECT pPos FROM tryout GROUP BY pPos ORDER BY COUNT( * ) DESC LIMIT 1 );
human
And what decisions resulted from those tryouts?
assistant
SELECT decision FROM tryout WHERE pPos = ( SELECT pPos FROM tryout GROUP BY pPos ORDER BY COUNT( * ) DESC LIMIT 1 );
human
Were there any other position in the try outs other than goalie position?
assistant
SELECT pPos FROM tryout WHERE pPos ! = 'goalie';
human
Which colleges were those positions for?
assistant
SELECT cName FROM tryout WHERE pPos ! = "goalie" ;