Can you list all the names of the students who have the position of striker?
select t1.pname from player as t1 join tryout as t2 on t1.pid = t2.pid where t2.ppos = 'striker'
Can you also list the tryout decision they got please?
select t1.pname,t2.decision from player as t1 join tryout as t2 on t1.pid = t2.pid where t2.ppos = 'striker'
What are the names and positions of all players who got a no for their tryout decision?
select t1.pname,t2.ppos from player as t1 join tryout as t2 on t1.pid = t2.pid where t2.decision = "no"
What are the names and college names of all players who have over 700 training hours?
select t1.pname,t2.cname from player as t1 join tryout as t2 on t1.pid = t2.pid where t1.hs > 700
Can you add their positions into the table please?
select t1.pname,t2.cname,t2.ppos from player as t1 join tryout as t2 on t1.pid = t2.pid where t1.hs > 700