CREATE TABLE table_train_279 ("id" NUMBER, "systolic_blood_pressure_sbp" NUMBER, "hemoglobin_a1c_hba1c" FLOAT, "estimated_glomerular_filtration_rate_egfr" NUMBER, "fasting_plasma_glucose" NUMBER, "diastolic_blood_pressure_dbp" NUMBER, "body_mass_index_bmi" FLOAT, "NOUSE" FLOAT)

body mass index ( bmi ) 27 to 42 kg / m2
SELECT * FROM table_train_279 WHERE body_mass_index_bmi >= 27 AND body_mass_index_bmi <= 42
SELECT * FROM "table_train_279" WHERE "body_mass_index_bmi" <= 42 AND "body_mass_index_bmi" >= 27