Which Males Rank is the highest one that has Females (%) smaller than 40, and Females Rank smaller than 22?
CREATE TABLE table_name_93 (males_rank INTEGER, females___percentage_ VARCHAR, females_rank VARCHAR)
SELECT MAX(males_rank) FROM table_name_93 WHERE females___percentage_ < 40 AND females_rank < 22
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_93 (males_rank INTEGER, females___percentage_ VARCHAR, females_rank VARCHAR) Question: Which Males Rank is the highest one that has Females (%) smaller than 40, and Females Rank smaller than 22? [/INST] SELECT MAX(males_rank) FROM table_name_93 WHERE females___percentage_ < 40 AND females_rank < 22 </s>