CREATE TABLE table_dev_50 ("id" INT, "gender" TEXT, "hemoglobin_a1c_hba1c" FLOAT, "diabetic" TEXT, "estimated_glomerular_filtration_rate_egfr" INT, "hba1c" FLOAT, "age" FLOAT, "NOUSE" FLOAT)

female , > 55 to < 80 years
SELECT * FROM table_dev_50 WHERE gender = 'female' AND (age > 55 AND age < 80)
SELECT * FROM "table_dev_50" WHERE "age" < 80 AND "age" > 55 AND "gender" = 'female'