How many schools are there?
select count(*) from school;
How many don't have any players?
select count(*) from school where school_id not in (select school_id from player);
Which ones don't have any players?
select * from school where school_id not in (select school_id from player);
Show their locations.
select location from school where school_id not in (select school_id from player);