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)

Find the name of players whose card is yes in the descending order of training hours.
SELECT pname FROM player WHERE ycard = 'yes' ORDER BY hs DESC
SELECT "pname" FROM "player" WHERE "ycard" = 'yes' ORDER BY "hs" DESC