How many schools have an endowment?
select count(*) from school where school_id in (select school_id from endowment)
How many schools do not have an endowment?
select count(*) from school where school_id not in (select school_id from endowment)
List the names of these schools.
select school_name from school where school_id not in (select school_id from endowment)