Table: asbury_park_crime_stats
Columns: year
crime_index_total
violent_crime
non_violent_crime
crime_rate_per_1000
violent_crime_rate_per_1000
non_violent_crime_rate_per_1000
murder
rape
robbery
aggravated_assault

Question: How many total murders happened after 2011?
SQL: SELECT SUM("murder") FROM asbury_park_crime_stats WHERE "year" > 2011

Question: Which average Robbery has the following criteria: Non-Violent crime less than 1147, rape less then 11, aggrevated assault greater than 167 and a crime index with a total of 1313?
SQL: SELECT AVG("robbery") FROM asbury_park_crime_stats WHERE "non_violent_crime" < 1147 AND "rape" < 11 AND "aggravated_assault" > 167 AND "crime_index_total" = 1313

Question: Which non-violent crime rate per 1000 peope has the following criteria: crime rate per 1000 greater than 82.8, violent crime smaller than 305, robbery less than 147 and a crime index total greater than 1540?
SQL: SELECT AVG("violent_crime_rate_per_1000") FROM asbury_park_crime_stats WHERE "crime_rate_per_1000" > 82.8 AND "violent_crime" < 305 AND "robbery" < 147 AND "crime_index_total" > 1540

Question: Which aggravated assault has the highest amount and the following criteria: crime rate per 1000 greater than 89.1,rape value of 23, and a crime index greater than 1590?
SQL: SELECT MAX("aggravated_assault") FROM asbury_park_crime_stats WHERE "crime_rate_per_1000" > 89.1 AND "rape" = 23 AND "crime_index_total" > 1590