Table: crime_stats_usa
Columns: state
city
population
violent_crime
murder_and_non_negligent_manslaughter
forcible_rape
robbery
aggravated_assault
property_crime
burglary
larceny_theft
motor_vehicle_theft

Question: What was the population of Minneapolis in 2012?
SQL: SELECT MAX("population") FROM crime_stats_usa WHERE "city" = 'Minneapolis'

Question: How many burglaries occurred in the city where the violent crime rate was 974.7?
SQL: SELECT "burglary" FROM crime_stats_usa WHERE "violent_crime" = '974.7'

Question: What was the violent crime rate in the city where the robbery rate was 201.4?
SQL: SELECT "violent_crime" FROM crime_stats_usa WHERE "robbery" = '201.4'

Question: How many cities were there in 2012 where the rate of burglary was 224.8?
SQL: SELECT COUNT("property_crime") FROM crime_stats_usa WHERE "burglary" = '224.8'