CREATE TABLE table_dev_45 ("id" NUMBER, "tc" NUMBER, "systolic_blood_pressure_sbp" NUMBER, "parenteral_antibiotic_therapy" BOOLEAN, "fasting_plasma_glucose_fpg" FLOAT, "active_infection" BOOLEAN, "untreated_hyperlipidemia" BOOLEAN, "hemoglobin_a1c_hba1c" FLOAT, "temperature" FLOAT, "diastolic_blood_pressure_dbp" NUMBER, "tgc" NUMBER, "causing_fever" BOOLEAN, "diabetes" BOOLEAN, "ldl" NUMBER, "alcohol_abuse" BOOLEAN, "a1c" FLOAT, "NOUSE" FLOAT)

fasting plasma glucose ( fpg ) 80 , 140 mg / dl and glycated hemoglobin ( a1c ) > 6.5 % and < or = 10 % .
SELECT * FROM table_dev_45 WHERE fasting_plasma_glucose_fpg >= 80 AND fasting_plasma_glucose_fpg <= 140 AND (hemoglobin_a1c_hba1c > 6.5 AND hemoglobin_a1c_hba1c <= 10)
SELECT * FROM "table_dev_45" WHERE "fasting_plasma_glucose_fpg" <= 140 AND "fasting_plasma_glucose_fpg" >= 80 AND "hemoglobin_a1c_hba1c" <= 10 AND "hemoglobin_a1c_hba1c" > 6.5