SELECT name FROM city WHERE county_id IN (SELECT county_id FROM county_public_safety WHERE Crime_rate  <  100)
Show the names of cities in counties that have a crime rate less than 100.
SELECT name FROM city WHERE county_id IN ( SELECT county_id FROM county_public_safety WHERE Crime_rate < 100 )
select name from city where county_id in ( select county_id from county_public_safety where crime_rate < value )
Show the names of cities in counties that have a crime rate less than 100 .