What information is there on the player named Charles?
select * from player where pname = 'Charles'
What college is he 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 state is that college located in?
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 t3.pname = 'Charles'