CREATE TABLE table_dev_52 ("id" INT, "anemia" BOOLEAN, "gender" TEXT, "prediabetes" BOOLEAN, "systolic_blood_pressure_sbp" INT, "metabolic_syndrome" BOOLEAN, "hemoglobin_a1c_hba1c" FLOAT, "dyslipidemia" BOOLEAN, "dsp" INT, "renal_disease" BOOLEAN, "hepatic_disease" BOOLEAN, "elevated_triglyceride" INT, "chronic_hematology_disorders" BOOLEAN, "ldl" INT, "serum_creatinine" FLOAT, "diagnosed_hypertension" BOOLEAN, "waist_circumference" INT, "triglyceride_tg" FLOAT, "low_hdl" INT, "fasting_glucose" INT, "NOUSE" FLOAT)

individuals who are found to have metabolic syndrome. metabolic syndrome is defined as having at least 3 of the 5 following risk factors: waist circumference ( > 40 inches male , > 35 inches female ) ; blood pressure > 130 mmhg ( systolic ) or > 85 mmhg ( diastolic ) or history of diagnosed hypertension ; low hdl level ( < 40 mg / dl male , < 50 mg / dl female ) ; elevated triglyceride level > 150 mg / dl ; fasting glucose > 100 mg / dl and < 126 mg / dl
SELECT * FROM table_dev_52 WHERE metabolic_syndrome = 1 OR (CASE WHEN (waist_circumference > 40 AND gender = 'male') OR (waist_circumference > 35 AND gender = 'female') THEN 1 ELSE 0 END + CASE WHEN systolic_blood_pressure_sbp > 130 OR dsp > 85 OR diagnosed_hypertension = 1 THEN 1 ELSE 0 END + CASE WHEN (low_hdl < 40 AND gender = 'male') OR (low_hdl < 50 AND gender = 'female') THEN 1 ELSE 0 END + CASE WHEN elevated_triglyceride > 150 THEN 1 ELSE 0 END + CASE WHEN fasting_glucose > 100 AND fasting_glucose < 126 THEN 1 ELSE 0 END) >= 3
SELECT * FROM "table_dev_52" WHERE "metabolic_syndrome" = 1 OR (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 "diagnosed_hypertension" = 1 OR "dsp" > 85 OR "systolic_blood_pressure_sbp" > 130 THEN 1 ELSE 0 END + CASE WHEN ("gender" = 'female' OR "gender" = 'male') AND ("gender" = 'female' OR "low_hdl" < 40) AND "low_hdl" < 50 THEN 1 ELSE 0 END + CASE WHEN "elevated_triglyceride" > 150 THEN 1 ELSE 0 END + CASE WHEN "fasting_glucose" < 126 AND "fasting_glucose" > 100 THEN 1 ELSE 0 END) >= 3