I want to know the states and the college names which have some college students in tryout.
select t1.state, t1.cname from college as t1 join tryout as t2 on t1.cname = t2.cname
Hmm, can you show me the college names with players whose decisions are yes?
select cname from tryout where decision = "yes"
Can you list just the states which have college students in tryout and their decisions are yes?
select distinct t1.state from college as t1 join tryout as t2 on t1.cname = t2.cname where t2.decision = 'yes'