Which Females Rank is the highest one that has Females (%) larger than 53, and an HIV awareness (males%) smaller than 89, and a State of odisha?
CREATE TABLE table_name_2 (females_rank INTEGER, state VARCHAR, females___percentage_ VARCHAR, hiv_awareness__males_percentage_ VARCHAR)
SELECT MAX(females_rank) FROM table_name_2 WHERE females___percentage_ > 53 AND hiv_awareness__males_percentage_ < 89 AND state = "odisha"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_2 (females_rank INTEGER, state VARCHAR, females___percentage_ VARCHAR, hiv_awareness__males_percentage_ VARCHAR) Question: Which Females Rank is the highest one that has Females (%) larger than 53, and an HIV awareness (males%) smaller than 89, and a State of odisha? [/INST] SELECT MAX(females_rank) FROM table_name_2 WHERE females___percentage_ > 53 AND hiv_awareness__males_percentage_ < 89 AND state = "odisha" </s>