CREATE TABLE city (name VARCHAR2, county_id VARCHAR2, Crime_rate NUMBER)
CREATE TABLE county_public_safety (name VARCHAR2, county_id VARCHAR2, Crime_rate NUMBER)

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)