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)
crime rate less than 100 refers to Crime_rate < 100; cities in counties refers to JOIN or IN condition between city and county based on county_id;