Database: county_public_safety
Question: Show the names of cities in counties that have a crime rate less than 100.
SQL:
SELECT name FROM city WHERE county_id IN (SELECT county_id FROM county_public_safety WHERE Crime_rate  <  100)