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

For each position, what is the maximum number of hours for students who spent more than 1000 hours training?
SELECT MAX(T1.hs), ppos FROM player AS T1 JOIN tryout AS T2 ON T1.pid = T2.pid WHERE T1.hs > 1000 GROUP BY T2.ppos
SELECT MAX("T1"."hs"), "ppos" FROM "player" "T1" JOIN "tryout" "T2" ON "T1"."pid" = "T2"."pid" WHERE "T1"."hs" > 1000 GROUP BY "T2"."ppos"