Which Females (%) has an HIV awareness (males%) larger than 92, and Females Rank larger than 2, and Males Rank smaller than 3?
CREATE TABLE "references" (
  "males_rank" real,
  "females_rank" real,
  "state" text,
  "hiv_awareness_malespct" real,
  "females_pct" real
);
SELECT SUM("females_pct") FROM "references" WHERE "hiv_awareness_malespct">92 AND "females_rank">2 AND "males_rank"<3;