Could you please get me the name of the county with the largest population?
select name from county_public_safety order by population desc limit 1
How many police officers are there in that county?
select police_officers from county_public_safety order by population desc limit 1
Yes, please.
select name from county_public_safety where police_officers > ( select police_officers from county_public_safety order by population desc limit 1 )
Which county has the lowest amount of police officers?
select name from county_public_safety order by population limit 1
How many police officers are in that county?
select police_officers from county_public_safety order by police_officers limit 1