How many hours does a goalie need to play to meet the minimum?
select min ( t2.hs ) from tryout as t1 join player as t2 on t1.pid = t2.pid and t1.ppos = 'goalie' group by t1.ppos
How many hours does a striker need to play to meet the minimum?
select min ( t2.hs ) from tryout as t1 join player as t2 on t1.pid = t2.pid and t1.ppos = 'striker' group by t1.ppos
How many hours does a mid need to play to meet the minimum?
select min ( t2.hs ) from tryout as t1 join player as t2 on t1.pid = t2.pid where t1.ppos = "mid" group by t1.ppos