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)
CREATE TABLE city (city_id NUMBER, county_id NUMBER, name CLOB, white NUMBER, black NUMBER, amerindian NUMBER, asian NUMBER, multiracial NUMBER, hispanic NUMBER)

Show white percentages of cities and the crime rates of counties they are in.
SELECT T1.white, T2.crime_rate FROM city AS T1 JOIN county_public_safety AS T2 ON T1.county_id = T2.county_id
SELECT "T1"."white", "T2"."crime_rate" FROM "city" "T1" JOIN "county_public_safety" "T2" ON "T1"."county_id" = "T2"."county_id"