CREATE TABLE table_train_270 ("id" NUMBER, "gender" CLOB, "allergy_to_omega_3" BOOLEAN, "serum_low_density_lipoprotein_cholesterol" NUMBER, "stimulated_c_peptide" FLOAT, "allergy_to_dha" BOOLEAN, "allergy_to_vitamin_d" BOOLEAN, "serum_triglyceride" NUMBER, "age" FLOAT, "NOUSE" FLOAT)

male and female 18 to 80 years of age
SELECT * FROM table_train_270 WHERE (gender = 'male' OR gender = 'female') AND (age >= 18 AND age <= 80)
SELECT * FROM "table_train_270" WHERE "age" <= 80 AND "age" >= 18 AND ("gender" = 'female' OR "gender" = 'male')