Table: hiv_awareness_rank
Columns: males_rank
females_rank
state
hiv_awareness_males
females

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?
SQL: SELECT MAX("females_rank") FROM hiv_awareness_rank WHERE "females" > 53 AND "hiv_awareness_males" < 89 AND "state" = 'odisha'

Question: How many Females (%) have Females Rank smaller than 21, and a State of kerala, and Males Rank larger than 1?
SQL: SELECT COUNT("females") FROM hiv_awareness_rank WHERE "females_rank" < 21 AND "state" = 'kerala' AND "males_rank" > 1

Question: How many Females (%) have a State of karnataka, and Males Rank larger than 16?
SQL: SELECT COUNT("females") FROM hiv_awareness_rank WHERE "state" = 'karnataka' AND "males_rank" > 16

Question: Which Males Rank is the highest one that has Females (%) smaller than 40, and Females Rank smaller than 22?
SQL: SELECT MAX("males_rank") FROM hiv_awareness_rank WHERE "females" < 40 AND "females_rank" < 22

Question: Which Females (%) has an HIV awareness (males%) larger than 92, and Females Rank larger than 2, and Males Rank smaller than 3?
SQL: SELECT SUM("females") FROM hiv_awareness_rank WHERE "hiv_awareness_males" > 92 AND "females_rank" > 2 AND "males_rank" < 3