find the name and college of students whose player position are goalie in the tryout
select t1.pname, t2.cname from player as t1 join tryout as t2 on t1.pid = t2.pid where t2.ppos = 'goalie'
find the training hours for the player id 10001
select hs from player where pid = "10001"
find the college name for the player id 10001
select t2.cname from player as t1 join tryout as t2 on t1.pid = t2.pid where t2.pid = '10001'