CREATE TABLE table_train_3 ("id" NUMBER, "pregnancy_or_lactation" BOOLEAN, "severe_sepsis" BOOLEAN, "systolic_blood_pressure_sbp" NUMBER, "mean_arterial_pressure_map" NUMBER, "leukocyte_count" NUMBER, "renal_disease" BOOLEAN, "temperature" FLOAT, "sepsis" BOOLEAN, "hypotension" BOOLEAN, "heart_rate" NUMBER, "paco2" FLOAT, "chronic_respiratory_disease" BOOLEAN, "hypoperfusion" BOOLEAN, "immature_form" NUMBER, "organ_failure" BOOLEAN, "septic_shock" BOOLEAN, "respiratory_rate" NUMBER, "age" FLOAT, "NOUSE" FLOAT)

patients who diagnosed as severe sepsis or septic shock, either at admission or during the icu stay. sepsis is the systemic response to infections defined by 2 or more of the following conditions: body temperature of > 38 oc or < 36 oc; heart rate of > 90 beats per min; respiratory rate of > 20 breaths per min or a paco2 of < 32 mmhg; or leukocyte count > 12000 cell / mm3, < 4000 cell / mm3 or 10 % immature ( band ) forms. severe sepsis is defined by sepsis associated with organ dysfunction, hypoperfusion, or hypotension ( systolic arterial pressure < 90 mmhg, mean arterial pressure < 70 mmhg or a reduction of >= 40 mmhg from baseline ) . septic shock is defined by severe sepsis associated with hypotension despite adequate fluid resuscitation
SELECT * FROM table_train_3 WHERE severe_sepsis = 1 OR septic_shock = 1 OR ((CASE WHEN temperature > 38 OR temperature < 36 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 leukocyte_count > 12000 OR leukocyte_count < 4000 OR immature_form = 10 THEN 1 ELSE 0 END) >= 2 OR sepsis = 1) AND (organ_failure = 1 OR hypoperfusion = 1 OR hypotension = 1 OR systolic_blood_pressure_sbp < 90 OR mean_arterial_pressure_map < 70) OR (severe_sepsis = 1 AND hypotension = 1)
SELECT * FROM "table_train_3" WHERE ("hypoperfusion" = 1 OR "hypotension" = 1 OR "mean_arterial_pressure_map" < 70 OR "organ_failure" = 1 OR "systolic_blood_pressure_sbp" < 90) AND ("sepsis" = 1 OR "septic_shock" = 1 OR "severe_sepsis" = 1 OR (CASE WHEN "temperature" < 36 OR "temperature" > 38 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 "immature_form" = 10 OR "leukocyte_count" < 4000 OR "leukocyte_count" > 12000 THEN 1 ELSE 0 END) >= 2)