CREATE TABLE table_dev_34 ("id" NUMBER, "gender" CLOB, "heart_disease" BOOLEAN, "body_weight" FLOAT, "hematocrit_hct" FLOAT, "fasting_blood_glucose_fbg" FLOAT, "hyperlipidemia" BOOLEAN, "systemic_illness" BOOLEAN, "angina" BOOLEAN, "serum_ldl" NUMBER, "clinically_significant_atherosclerotic_vascular_disease" BOOLEAN, "impaired_glucose_tolerance" BOOLEAN, "fbg" NUMBER, "post_prandial_pp" NUMBER, "significant_nephropathy" BOOLEAN, "serum_tg" NUMBER, "proteinuria" NUMBER, "body_mass_index_bmi" FLOAT, "plasma_creatinine" FLOAT, "cfrd" BOOLEAN, "NOUSE" FLOAT)

hematocrit of less than 36 % for male , less than 32 % for female .
SELECT * FROM table_dev_34 WHERE (hematocrit_hct < 36 AND gender = 'male') OR (hematocrit_hct < 32 AND gender = 'female')
SELECT * FROM "table_dev_34" WHERE ("gender" = 'female' OR "gender" = 'male') AND ("gender" = 'male' OR "hematocrit_hct" < 32) AND "hematocrit_hct" < 36