CREATE TABLE table_train_245 ("id" INT, "renal_disease" BOOLEAN, "diabetic" TEXT, "creatinine_clearance_cl" FLOAT, "smoking" BOOLEAN, "kidney_disease" BOOLEAN, "body_mass_index_bmi" FLOAT, "fasting_glucose" INT, "NOUSE" FLOAT)

body mass index > 27 and < 43 kg / m2
SELECT * FROM table_train_245 WHERE body_mass_index_bmi > 27 AND body_mass_index_bmi < 43
SELECT * FROM "table_train_245" WHERE "body_mass_index_bmi" < 43 AND "body_mass_index_bmi" > 27