How many counties are there?
select count ( * ) from county_public_safety
yes
select name from county_public_safety order by crime_rate asc limit 1
which county has the highest crime rate?
select name from county_public_safety order by crime_rate desc limit 1
yes
select name, crime_rate from county_public_safety where name = 'Campbell River' or name = 'Central Saanich'
no, just for the 2 counties from the previous query
select name, crime_rate from county_public_safety where name = 'Campbell River' or name = 'Central Saanich' order by crime_rate asc