CREATE TABLE table_dev_31 ("id" NUMBER, "gender" CLOB, "pre_dm" BOOLEAN, "hemoglobin_a1c_hba1c" FLOAT, "renal_disease" BOOLEAN, "diabetic" CLOB, "fasting_blood_glucose_fbg" FLOAT, "creatinine_clearance_cl" FLOAT, "estimated_glomerular_filtration_rate_egfr" NUMBER, "fasting_plasma_glucose" NUMBER, "early_dm" BOOLEAN, "oral_glucose_tolerance_test" NUMBER, "baseline_hemoglobin_hgb" FLOAT, "random_plasma_glucose_concentration" NUMBER, "body_mass_index_bmi" FLOAT, "glycosylated_hemoglobin" FLOAT, "NOUSE" FLOAT)

fasting blood sugar equal or greater than 100 mg / dl, or pre _ dm ( hba1c 5.7 _ 6.4 % ) or early dm ( hba1c >= 6.5 % )
SELECT * FROM table_dev_31 WHERE fasting_blood_glucose_fbg >= 100 OR (pre_dm = 1 AND hemoglobin_a1c_hba1c > 5.7 AND hemoglobin_a1c_hba1c < 6.4) OR (early_dm = 1 AND hemoglobin_a1c_hba1c >= 6.5)
SELECT * FROM "table_dev_31" WHERE ("early_dm" = 1 OR "fasting_blood_glucose_fbg" >= 100 OR "hemoglobin_a1c_hba1c" < 6.4) AND ("early_dm" = 1 OR "fasting_blood_glucose_fbg" >= 100 OR "pre_dm" = 1) AND ("fasting_blood_glucose_fbg" >= 100 OR "hemoglobin_a1c_hba1c" < 6.4 OR "hemoglobin_a1c_hba1c" >= 6.5) AND ("fasting_blood_glucose_fbg" >= 100 OR "hemoglobin_a1c_hba1c" > 5.7) AND ("fasting_blood_glucose_fbg" >= 100 OR "hemoglobin_a1c_hba1c" >= 6.5 OR "pre_dm" = 1)