CREATE TABLE college (cname CLOB, state CLOB, enr NUMBER)
CREATE TABLE player (pid NUMBER, pname CLOB, ycard CLOB, hs NUMBER)
CREATE TABLE tryout (pid NUMBER, cname CLOB, ppos CLOB, decision CLOB)

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'
SELECT "T1"."state" FROM "college" "T1" JOIN "tryout" "T2" ON "T1"."cname" = "T2"."cname" JOIN "player" "T3" ON "T2"."pid" = "T3"."pid" AND "T3"."pname" = 'Charles'