Which colleges were those positions for?
SELECT cName FROM tryout where pPos ! =  "goalie"
colleges refers to cName; positions refers to pPos; goalie is a type of position, and the requirement is for positions other than goalie, which is represented as pPos != 'goalie'