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

Which colleges does each player with a name that starts with the letter D who tried out go to?
SELECT T1.cname FROM tryout AS T1 JOIN player AS T2 ON T1.pid = T2.pid WHERE T2.pname LIKE 'D%'
SELECT "T1"."cname" FROM "tryout" "T1" JOIN "player" "T2" ON "T1"."pid" = "T2"."pid" AND "T2"."pname" LIKE 'D%'