What information is there on students who spent more than 1000 hours training?
select * from player where hs > 1000
For each position, how many hours did each student spent training?
select t1.hs, ppos from player as t1 join tryout as t2 on t1.pid = t2.pid group by t2.ppos
What was the maximum time spent for each position?
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