How many players are there?
select count(*) from player
What about coaches?
select count(*) from coach
Which players do not have a coach?
select player_name from player where player_id not in (select player_id from player_coach)