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

What was the most popular position at tryouts?
SELECT ppos FROM tryout GROUP BY ppos ORDER BY COUNT(*) DESC LIMIT 1
SELECT "ppos" FROM "tryout" GROUP BY "ppos" ORDER BY COUNT(*) DESC FETCH FIRST 1 ROWS ONLY