CREATE TABLE table_name_40 (robbery NUMBER, crime_index_total VARCHAR2, aggravated_assault VARCHAR2, non_violent_crime VARCHAR2, rape VARCHAR2)

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?
SELECT AVG(robbery) FROM table_name_40 WHERE non_violent_crime < 1147 AND rape < 11 AND aggravated_assault > 167 AND crime_index_total = 1313
SELECT AVG("robbery") FROM "table_name_40" WHERE "aggravated_assault" > 167 AND "crime_index_total" = 1313 AND "non_violent_crime" < 1147 AND "rape" < 11