find the state of the college which player Charles is attending
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'
OK,List out the all player id and college name
select t1.cname, t3.pid from college as t1 join tryout as t2 on t1.cname = t2.cname join player as t3 on t2.pid = t3.pid
find the training hours of the player Charles
select hs from player where pname = 'Charles'
ok, list out all college name
select cname from college