can you show me a list of player position?
select ppos from tryout
can you show me a list of college name?
select cname from college
what is the average of enrollments?
select avg ( enr ) from college
what is the colleges' states?
select state from college
find the names of states that have some collage plating in goalie and mid positions.
select t1.state from college as t1 join tryout as t2 on t1.cname = t2.cname where t2.ppos = 'goalie' intersect select t1.state from college as t1 join tryout as t2 on t1.cname = t2.cname where t2.ppos = 'mid'