Show the name of cities in the county that has the largest number of police officers.
select name from city where county_id = ( select county_id from county_public_safety order by police_officers desc limit 1 )
Yes Aibonito, my mistake
select police_officers from county_public_safety where county_id = ( select county_id from city where name = 'Aibonito' )
What is the population of Aibonito?
select population from county_public_safety where county_id = ( select county_id from city where name = 'Aibonito' )
What is the crime rate in Aibonito?
select crime_rate from county_public_safety where county_id = ( select county_id from city where name = 'Aibonito' )
How many residents per officer are there in Aibonito?
select residents_per_officer from county_public_safety where county_id = ( select county_id from city where name = 'Aibonito' )