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?
CREATE TABLE table_name_90 (aggravated_assault INTEGER, crime_index_total VARCHAR, crime_rate_per_1000 VARCHAR, rape VARCHAR)
SELECT MAX(aggravated_assault) FROM table_name_90 WHERE crime_rate_per_1000 > 89.1 AND rape = 23 AND crime_index_total > 1590
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_90 (aggravated_assault INTEGER, crime_index_total VARCHAR, crime_rate_per_1000 VARCHAR, rape VARCHAR) 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? [/INST] SELECT MAX(aggravated_assault) FROM table_name_90 WHERE crime_rate_per_1000 > 89.1 AND rape = 23 AND crime_index_total > 1590 </s>