How many players have a yCard?
select count ( * ) from player where ycard = "yes"
What is the average HS score of all players?
select avg ( hs ) from player
Which player has the lowest HS score?
select pname from player order by hs asc limit 1
What is the pID for Andrew?
select pid from player where pname = "Andrew"
And for Blake?
select pid from player where pname = "Blake"
How many players are there?
select count ( * ) from player
What are there names?
select pname from player