CREATE TABLE table_dev_49 ("id" NUMBER, "gender" CLOB, "systolic_blood_pressure_sbp" NUMBER, "renal_disease" BOOLEAN, "diastolic_blood_pressure_dbp" NUMBER, "high_density_lipoprotein_cholesterol_hdl_c" NUMBER, "serum_creatinine" FLOAT, "waist_circumference" NUMBER, "triglyceride_tg" FLOAT, "hypertension" BOOLEAN, "NOUSE" FLOAT)

any 2 of the following: waist circumference > 40 inches in male , > 35 inches in female ; triglycerides > 150 mg / dl; high _ density lipoprotein cholesterol ( hdl _ c ) < 40 mg / dl in male , < 50 mg / dl in female ; systolic blood pressure > 130 mm hg or diastolic blood pressure > 85 mm hg.
SELECT * FROM table_dev_49 WHERE (CASE WHEN (waist_circumference > 40 AND gender = 'male') OR (waist_circumference > 35 AND gender = 'female') THEN 1 ELSE 0 END + CASE WHEN triglyceride_tg > 150 THEN 1 ELSE 0 END + CASE WHEN (high_density_lipoprotein_cholesterol_hdl_c < 40 AND gender = 'male') OR (high_density_lipoprotein_cholesterol_hdl_c < 50 AND gender = 'female') THEN 1 ELSE 0 END + CASE WHEN systolic_blood_pressure_sbp > 130 OR diastolic_blood_pressure_dbp > 85 THEN 1 ELSE 0 END) >= 2
SELECT * FROM "table_dev_49" WHERE (CASE WHEN ("gender" = 'female' OR "gender" = 'male') AND ("gender" = 'female' OR "waist_circumference" > 40) AND "waist_circumference" > 35 THEN 1 ELSE 0 END + CASE WHEN "triglyceride_tg" > 150 THEN 1 ELSE 0 END + CASE WHEN ("gender" = 'female' OR "gender" = 'male') AND ("gender" = 'female' OR "high_density_lipoprotein_cholesterol_hdl_c" < 40) AND "high_density_lipoprotein_cholesterol_hdl_c" < 50 THEN 1 ELSE 0 END + CASE WHEN "diastolic_blood_pressure_dbp" > 85 OR "systolic_blood_pressure_sbp" > 130 THEN 1 ELSE 0 END) >= 2