How many cities does each county have?
select county_id, count(*) from city group by county_id
Could you order the results by the number of cities?
select county_id, count(*) from city group by county_id order by count(*) desc
Which counties do not have any cities? List their names.
select name from county_public_safety where county_id not in (select county_id from city)