human
Schema:
College (cName, state, enr)
Player (pID, pName, yCard, HS)
Tryout (pID, cName, pPos, decision)
Please answer with SQL.
assistant
Sure, I understand.
human
How many different positions are there?
assistant
SELECT COUNT( distinct pPos ) FROM tryout;
human
How many students have more than 1000 hours of training?
assistant
SELECT * FROM player WHERE hs > 1000;
human
How many hours of training has the student with the most hours completed?
assistant
SELECT hs FROM player ORDER by hs desc LIMIT 1 ;