CREATE TABLE table_dev_47 ("id" INT, "gender" TEXT, "gestational_diabetes" BOOLEAN, "systolic_blood_pressure_sbp" INT, "leukopenia" INT, "hemoglobin_a1c_hba1c" FLOAT, "cd4_count" INT, "platelets" INT, "diabetic" TEXT, "elevated_blood_pressure" BOOLEAN, "diastolic_blood_pressure_dbp" INT, "lymphopenia" INT, "diabetes" BOOLEAN, "serum_creatinine" FLOAT, "prior_elevated_fasting_glucose" BOOLEAN, "baseline_hemoglobin_hgb" FLOAT, "body_mass_index_bmi" FLOAT, "age" FLOAT, "NOUSE" FLOAT)

increased risk for diabetes type ii by one of the following characteristics: ( 1 ) bmi > 30 , ( 2 ) age > 45 , ( 3 ) history of gestational diabetes, ( 4 ) prior elevated fasting glucose in the previous year.
SELECT * FROM table_dev_47 WHERE diabetic = 'ii' OR (CASE WHEN body_mass_index_bmi > 30 THEN 1 ELSE 0 END + CASE WHEN age > 45 THEN 1 ELSE 0 END + CASE WHEN gestational_diabetes = 1 THEN 1 ELSE 0 END + CASE WHEN prior_elevated_fasting_glucose = 1 THEN 1 ELSE 0 END) >= 1
SELECT * FROM "table_dev_47" WHERE "diabetic" = 'ii' OR (CASE WHEN "body_mass_index_bmi" > 30 THEN 1 ELSE 0 END + CASE WHEN "age" > 45 THEN 1 ELSE 0 END + CASE WHEN "gestational_diabetes" = 1 THEN 1 ELSE 0 END + CASE WHEN "prior_elevated_fasting_glucose" = 1 THEN 1 ELSE 0 END) >= 1