Table: law_enforcement_bc_2005
Columns: municipality
population
police_officers
residents_per_officer
total_costs_2005
cost_per_capita
case_burden
crime_rate_per_1_000_people
police_force

Question: Which police force serves a population of 17000?
SQL: SELECT "police_force" FROM law_enforcement_bc_2005 WHERE "population" = 17000

Question: When total costs (2005) are $700,116, what is the cost per capita?
SQL: SELECT "cost_per_capita" FROM law_enforcement_bc_2005 WHERE "total_costs_2005" = '$700,116'

Question: What is the cost per capita in the Courtenay municipality?
SQL: SELECT "cost_per_capita" FROM law_enforcement_bc_2005 WHERE "municipality" = 'Courtenay'

Question: Which crime rate per 1,000 people is associated with a cost per capita of $152?
SQL: SELECT MAX("crime_rate_per_1_000_people") FROM law_enforcement_bc_2005 WHERE "cost_per_capita" = '$152'

Question: If the number of police officers is 94, what is the lowest population number?
SQL: SELECT MIN("population") FROM law_enforcement_bc_2005 WHERE "police_officers" = 94

Question: What is the value of total costs (2005) in the Coldstream municipality?
SQL: SELECT "total_costs_2005" FROM law_enforcement_bc_2005 WHERE "municipality" = 'Coldstream'