text: Below is an context that describes a sql query, paired with an question that provides further information. Write an answer that appropriately completes the request.  # noqa: E501
  ### Context:
  CREATE TABLE table_name_40 (robbery INTEGER, crime_index_total VARCHAR, aggravated_assault VARCHAR, non_violent_crime VARCHAR, rape VARCHAR)
  ### 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?
  ### Answer:
  SELECT AVG(robbery) FROM table_name_40 WHERE non_violent_crime < 1147 AND rape < 11 AND aggravated_assault > 167 AND crime_index_total = 1313