CREATE TABLE table_train_34 ("id" NUMBER, "gender" CLOB, "allergy_to_adhesive" BOOLEAN, "contraception" BOOLEAN, "use_of_cyclosporin" BOOLEAN, "use_of_digoxin" BOOLEAN, "liver_disease" BOOLEAN, "rhabomyolysis" BOOLEAN, "allergy_to_hydrocortisone" BOOLEAN, "use_of_statins" BOOLEAN, "NOUSE" FLOAT)

effective contraception in fertile female
SELECT * FROM table_train_34 WHERE contraception = 1 AND gender = 'female'
SELECT * FROM "table_train_34" WHERE "contraception" = 1 AND "gender" = 'female'