What is the player id for Charles?
select pid from player where pname = "Charles"
What the college Charles is attending?
select t1.cname from college as t1 join tryout as t2 on t1.cname = t2.cname join player as t3 on t2.pid = t3.pid where t3.pname = 'Charles'
What is the state of the college OU?
select t1.state from college as t1 join tryout as t2 on t1.cname = t2.cname join player as t3 on t2.pid = t3.pid where t1.cname = 'OU'