Database: county_public_safety
Question: What are the names of cities that are in counties that have a crime rate below 100?
SQL:
SELECT name FROM city WHERE county_id IN (SELECT county_id FROM county_public_safety WHERE Crime_rate  <  100)