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

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" "T1" JOIN "player" "T2" ON "T1"."pID" = "T2"."pID" AND "T2"."pName" LIKE 'D%'