CREATE TABLE player (pID VARCHAR, pName VARCHAR)
CREATE TABLE tryout (cName VARCHAR, pID VARCHAR)

Which colleges do the tryout players whose name starts with letter D 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" AS "T1" JOIN "player" AS "T2" ON "T1"."pID" = "T2"."pID" AND "T2"."pName" LIKE 'D%'