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

What are the names of players who train between 500 and 1500 hours?
SELECT pname FROM player WHERE hs BETWEEN 500 AND 1500
SELECT "pname" FROM "player" WHERE "hs" <= 1500 AND "hs" >= 500