CREATE TABLE table_train_227 ("id" NUMBER, "gender" CLOB, "diabetic" CLOB, "allergic_to_study_products" BOOLEAN, "hba1c" FLOAT, "a1c" FLOAT, "age" FLOAT, "NOUSE" FLOAT)

an a1c score greater than 7 and less than 14 .
SELECT * FROM table_train_227 WHERE a1c > 7 AND a1c < 14
SELECT * FROM "table_train_227" WHERE "a1c" < 14 AND "a1c" > 7