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)

Who are the players that have names containing the letter a?
SELECT DISTINCT pname FROM player WHERE pname LIKE '%a%'
SELECT DISTINCT "pname" FROM "player" WHERE "pname" LIKE '%a%'