CREATE TABLE table_train_230 ("id" NUMBER, "anemia" BOOLEAN, "diabetic" CLOB, "lactose_intolerance" BOOLEAN, "hb" FLOAT, "body_mass_index_bmi" FLOAT, "NOUSE" FLOAT)

bmi > 18.5 kg / m2 and < 40 kg / m2.
SELECT * FROM table_train_230 WHERE body_mass_index_bmi > 18.5 AND body_mass_index_bmi < 40
SELECT * FROM "table_train_230" WHERE "body_mass_index_bmi" < 40 AND "body_mass_index_bmi" > 18.5