Which schools have goalie player?
select cname from tryout where ppos = "goalie"
And which schools don't have a goalie player?
select cname from tryout where ppos ! = "goalie"