CREATE TABLE table_train_42 ("id" NUMBER, "taking_vitamin_c" BOOLEAN, "do_not_resuscitate_dnr" BOOLEAN, "allergy_to_thiamine" BOOLEAN, "taking_thiamine" BOOLEAN, "receiving_vasopressor" BOOLEAN, "sepsis" BOOLEAN, "hypotension" BOOLEAN, "allergy_to_vitamin_c" BOOLEAN, "glucose_6_phosphate_dehydrogenase_deficiency_g6pd" NUMBER, "limited_care" BOOLEAN, "septic_shock" BOOLEAN, "NOUSE" FLOAT)

known glucose 6 phosphate dehydrogenase deficiency
SELECT * FROM table_train_42 WHERE glucose_6_phosphate_dehydrogenase_deficiency_g6pd = 1
SELECT * FROM "table_train_42" WHERE "glucose_6_phosphate_dehydrogenase_deficiency_g6pd" = 1