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?
CREATE TABLE table_name_40 (
    robbery INTEGER,
    crime_index_total VARCHAR,
    aggravated_assault VARCHAR,
    non_violent_crime VARCHAR,
    rape VARCHAR
)
SELECT AVG(robbery) FROM table_name_40 WHERE non_violent_crime < 1147 AND rape < 11 AND aggravated_assault > 167 AND crime_index_total = 1313
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: 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? ### Input: CREATE TABLE table_name_40 (
    robbery INTEGER,
    crime_index_total VARCHAR,
    aggravated_assault VARCHAR,
    non_violent_crime VARCHAR,
    rape VARCHAR
) ### Response: SELECT AVG(robbery) FROM table_name_40 WHERE non_violent_crime < 1147 AND rape < 11 AND aggravated_assault > 167 AND crime_index_total = 1313