CREATE TABLE table_train_174 ("id" NUMBER, "fasting_plasma_glucose_fpg" FLOAT, "hemoglobin_a1c_hba1c" FLOAT, "substance_dependence" BOOLEAN, "estimated_glomerular_filtration_rate_egfr" NUMBER, "allergy_to_insulin_lispro" BOOLEAN, "urine_albumin_to_creatinine_ratio_uacr" NUMBER, "smoking" BOOLEAN, "NOUSE" FLOAT)

has hba1c levels at screening between 7 % and 10 %
SELECT * FROM table_train_174 WHERE hemoglobin_a1c_hba1c > 7 AND hemoglobin_a1c_hba1c < 10
SELECT * FROM "table_train_174" WHERE "hemoglobin_a1c_hba1c" < 10 AND "hemoglobin_a1c_hba1c" > 7