
select * from Player;

select * from Tryout;

help ...;

select * from Tryout WHERE pPos='goalie';

select * from Tryout WHERE pPos='goal';

select pID from Tryout WHERE pPos='goalie';

select * from Player;

select DISTINCT * from Player;

select DISTINCT pName,cName,pPos from Player,Tryout WHERE pPos='goalie' AND Player.pID=Tryout.pID;

select DISTINCT pName,cName,HS from Player,Tryout WHERE pPos='goalie' AND HS>1000  AND Player.pID=Tryout.pID;

select DISTINCT pName,cName,HS from Player,Tryout WHERE pPos='goalie' AND HS<1000  AND Player.pID=Tryout.pID;

select DISTINCT pID, pName,cName,HS from Player,Tryout WHERE pPos='goalie' AND HS>1000  AND Player.pID=Tryout.pID;

select DISTINCT Player.pID, pName,cName,HS from Player,Tryout WHERE pPos='goalie' AND HS>1000  AND Player.pID=Tryout.pID;

SELECT DISTINCT pName, Tryout.cName, state, decision FROM Player, College, Tryout WHERE Player.pID=Tryout.pID AND Tryout.cName=College.cName;

-- order

SELECT DISTINCT pName, Tryout.cName, state, decision FROM Player, College, Tryout WHERE Player.pID=Tryout.pID AND Tryout.cName=College.cName ORDER BY state;

SELECT DISTINCT pName, Tryout.cName, state, decision FROM Player, College, Tryout WHERE Player.pID=Tryout.pID AND Tryout.cName=College.cName ORDER BY decision desc, state;
