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 prediabetes. pre _ diabetes is defined as having a fasting glucose > 100 mg / dl and < 126 mg / dl.
SELECT * FROM table_dev_52 WHERE prediabetes = 1 OR (fasting_glucose > 100 AND fasting_glucose < 126)
SELECT * FROM "table_dev_52" WHERE ("fasting_glucose" < 126 OR "prediabetes" = 1) AND ("fasting_glucose" > 100 OR "prediabetes" = 1)