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

Show names of cities and names of counties they are in.
SELECT T1.name, T2.name FROM city AS T1 JOIN county_public_safety AS T2 ON T1.county_id = T2.county_id
SELECT "T1"."name", "T2"."name" FROM "city" "T1" JOIN "county_public_safety" "T2" ON "T1"."county_id" = "T2"."county_id"