CREATE TABLE table_train_221 ("id" NUMBER, "gender" CLOB, "body_mass_index_bmi" FLOAT, "age" FLOAT, "NOUSE" FLOAT)

male or female between 18 and 79 years of age.
SELECT * FROM table_train_221 WHERE (gender = 'male' OR gender = 'female') AND (age >= 18 AND age <= 79)
SELECT * FROM "table_train_221" WHERE "age" <= 79 AND "age" >= 18 AND ("gender" = 'female' OR "gender" = 'male')