CREATE TABLE table_dev_47 ("id" NUMBER, "gender" CLOB, "gestational_diabetes" BOOLEAN, "systolic_blood_pressure_sbp" NUMBER, "leukopenia" NUMBER, "hemoglobin_a1c_hba1c" FLOAT, "cd4_count" NUMBER, "platelets" NUMBER, "diabetic" CLOB, "elevated_blood_pressure" BOOLEAN, "diastolic_blood_pressure_dbp" NUMBER, "lymphopenia" NUMBER, "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