CREATE TABLE table_train_27 ("id" NUMBER, "bone_marrow_transplant" BOOLEAN, "antimicrobial_therapy" BOOLEAN, "immune_suppression" BOOLEAN, "hiv_infection" BOOLEAN, "autoimmune_disease" BOOLEAN, "hepatitis_b_infection" BOOLEAN, "renal_disease" BOOLEAN, "total_parenteral_nutrition" BOOLEAN, "surgery" BOOLEAN, "hepatitis_c_infection" BOOLEAN, "invasive_candida_infection" BOOLEAN, "NOUSE" FLOAT)

increased risk of invasive candida infection with at least 1 of the following criteria: total parenteral nutrition; abdominal surgery; antimicrobial therapy; acute or chronic renal failure with renal replacement therapy
SELECT * FROM table_train_27 WHERE invasive_candida_infection = 1 OR (CASE WHEN total_parenteral_nutrition = 1 THEN 1 ELSE 0 END + CASE WHEN surgery = 1 THEN 1 ELSE 0 END + CASE WHEN antimicrobial_therapy = 1 THEN 1 ELSE 0 END + CASE WHEN renal_disease = 1 THEN 1 ELSE 0 END) >= 1
SELECT * FROM "table_train_27" WHERE "invasive_candida_infection" = 1 OR (CASE WHEN "total_parenteral_nutrition" = 1 THEN 1 ELSE 0 END + CASE WHEN "surgery" = 1 THEN 1 ELSE 0 END + CASE WHEN "antimicrobial_therapy" = 1 THEN 1 ELSE 0 END + CASE WHEN "renal_disease" = 1 THEN 1 ELSE 0 END) >= 1