Find the states where have some college students in tryout and their decisions are yes.
create table tryout (cname varchar, decision varchar, PRIMARY KEY (cname)); create table college (state varchar, cname varchar, PRIMARY KEY (state))
select distinct t1.state from college as t1 join tryout as t2 on t1.cname = t2.cname where t2.decision = 'yes'