What are the names of colleges that have students who tried out for the goalie?
select cname from tryout where ppos = 'goalie'
Of those, which also have students who tried out for the position of mid-field?
select cname from tryout where ppos = 'goalie' intersect select cname from tryout where ppos = 'mid'