CREATE TABLE county_public_safety (county_id DECIMAL, name TEXT, population DECIMAL, police_officers DECIMAL, residents_per_officer DECIMAL, case_burden DECIMAL, crime_rate DECIMAL, police_force TEXT, location TEXT)
CREATE TABLE city (city_id DECIMAL, county_id DECIMAL, name TEXT, white DECIMAL, black DECIMAL, amerindian DECIMAL, asian DECIMAL, multiracial DECIMAL, hispanic DECIMAL)

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" < 100)