Which position is the most popular among players in the tryout?
select ppos from tryout group by ppos order by count ( * ) desc limit 1
What were the names of the colleges for that position?
select cname from tryout where ppos = ( select ppos from tryout group by ppos order by count ( * ) desc limit 1 )
And what decisions resulted from those tryouts?
select decision from tryout where ppos = ( select ppos from tryout group by ppos order by count ( * ) desc limit 1 )
Were there any other position in the try outs other than goalie position?
select ppos from tryout where ppos ! = "goalie"
Which colleges were those positions for?
select cname from tryout where ppos ! = "goalie"