CREATE TABLE table_dev_48 ("id" NUMBER, "gender" CLOB, "systolic_blood_pressure_sbp" NUMBER, "hiv_infection" BOOLEAN, "body_weight" FLOAT, "diabetic" CLOB, "active_hepatitis" BOOLEAN, "diastolic_blood_pressure_dbp" NUMBER, "liver_disease" BOOLEAN, "high_density_lipoprotein_cholesterol_hdl_c" NUMBER, "kidney_disease" BOOLEAN, "body_mass_index_bmi" FLOAT, "hypertension" BOOLEAN, "age" FLOAT, "NOUSE" FLOAT)

hdl _ c > 40 mg / dl for male , > 50 mg / dl for female
SELECT * FROM table_dev_48 WHERE (high_density_lipoprotein_cholesterol_hdl_c > 40 AND gender = 'male') OR (high_density_lipoprotein_cholesterol_hdl_c > 50 AND gender = 'female')
SELECT * FROM "table_dev_48" WHERE ("gender" = 'female' OR "gender" = 'male') AND ("gender" = 'male' OR "high_density_lipoprotein_cholesterol_hdl_c" > 50) AND "high_density_lipoprotein_cholesterol_hdl_c" > 40