CREATE TABLE table_train_233 ("id" NUMBER, "serum_bicarbonate" NUMBER, "language" CLOB, "hemoglobin_a1c_hba1c" FLOAT, "creatinine_clearance_cl" FLOAT, "admission_blood_glucose" NUMBER, "urine_albumin" NUMBER, "ketoacidosis" BOOLEAN, "age" FLOAT, "NOUSE" FLOAT)

hba1c of 6.5 to 8
SELECT * FROM table_train_233 WHERE hemoglobin_a1c_hba1c >= 6.5 AND hemoglobin_a1c_hba1c <= 8
SELECT * FROM "table_train_233" WHERE "hemoglobin_a1c_hba1c" <= 8 AND "hemoglobin_a1c_hba1c" >= 6.5