CREATE TABLE city (City_ID NUMBER, County_ID NUMBER, Name CLOB, White FLOAT, Black FLOAT, Amerindian FLOAT, Asian FLOAT, Multiracial FLOAT, Hispanic FLOAT)
CREATE TABLE county_public_safety (County_ID NUMBER, Name CLOB, Population NUMBER, Police_officers NUMBER, Residents_per_officer NUMBER, Case_burden NUMBER, Crime_rate FLOAT, Police_force CLOB, Location CLOB)

I want to know the proportion of the number of counties for each police force.
SELECT Police_force, COUNT(*) FROM county_public_safety GROUP BY Police_force
SELECT "Police_force", COUNT(*) FROM "county_public_safety" GROUP BY "Police_force"