CREATE TABLE table_train_8 ("id" INT, "white_blood_cell_count_wbc" INT, "systolic_blood_pressure_sbp" INT, "active_infection" BOOLEAN, "intention_to_arterial_catheter" BOOLEAN, "temperature" FLOAT, "intention_to_central_venous_catheter" BOOLEAN, "sepsis" BOOLEAN, "heart_rate" INT, "paco2" FLOAT, "hypoperfusion" BOOLEAN, "immature_form" INT, "respiratory_rate" INT, "lactate" INT, "NOUSE" FLOAT)

2 or more systemic inflammatory response syndrome ( sirs ) criteria: white blood cell count less than 4000 per mm3, greater than 12000 per mm3, or differential with greater than 10 % immature forms; heart rate greater than 90 beats per minute; respiratory rate greater than 20 breaths per minute or paco2 less than 32 mmhg; temperature less than 36 c or greater than 38 c
SELECT * FROM table_train_8 WHERE (CASE WHEN white_blood_cell_count_wbc < 4000 OR white_blood_cell_count_wbc > 12000 OR immature_form > 10 THEN 1 ELSE 0 END + CASE WHEN heart_rate > 90 THEN 1 ELSE 0 END + CASE WHEN respiratory_rate > 20 OR paco2 < 32 THEN 1 ELSE 0 END + CASE WHEN temperature > 38 OR temperature < 36 THEN 1 ELSE 0 END) >= 2
SELECT * FROM "table_train_8" WHERE (CASE WHEN "immature_form" > 10 OR "white_blood_cell_count_wbc" < 4000 OR "white_blood_cell_count_wbc" > 12000 THEN 1 ELSE 0 END + CASE WHEN "heart_rate" > 90 THEN 1 ELSE 0 END + CASE WHEN "paco2" < 32 OR "respiratory_rate" > 20 THEN 1 ELSE 0 END + CASE WHEN "temperature" < 36 OR "temperature" > 38 THEN 1 ELSE 0 END) >= 2