CREATE TABLE table_train_170 ("id" INT, "alt" FLOAT, "hemoglobin_a1c_hba1c" FLOAT, "ast" FLOAT, "allergy_to_peanuts" BOOLEAN, "a1c" FLOAT, "bilirubin" FLOAT, "NOUSE" FLOAT)

hba1c > 5.9 % and < 10 % ;
SELECT * FROM table_train_170 WHERE hemoglobin_a1c_hba1c > 5.9 AND hemoglobin_a1c_hba1c < 10
SELECT * FROM "table_train_170" WHERE "hemoglobin_a1c_hba1c" < 10 AND "hemoglobin_a1c_hba1c" > 5.9