CREATE TABLE table_train_70 ("id" INT, "pregnancy_or_lactation" BOOLEAN, "white_blood_cell_count_wbc" INT, "systolic_blood_pressure_sbp" INT, "mean_arterial_pressure_map" INT, "temperature" FLOAT, "oliguria" BOOLEAN, "surgery" BOOLEAN, "heart_rate" INT, "systemic_inflammatory_response" BOOLEAN, "paco2" FLOAT, "burn_injury" INT, "immature_form" INT, "mental_status" BOOLEAN, "respiratory_rate" INT, "age" FLOAT, "NOUSE" FLOAT)

patients with suspected or proven infection and 2 of the following 6 criteria: body temperature < 36 or > 38.3 celsius ; heart rate > 90 beats / min ; tachypnea > 20 / min or a arterial paco2 below 4.25 kpa ; white blood cell count higher than 12000 or below 4000 or more than 10 % immature forms ; systolic blood pressure < 90 mmhg or mean arterial pressure < 65 mmhg ; altered mental state or oliguria
SELECT * FROM table_train_70 WHERE (CASE WHEN temperature < 36 OR temperature > 38.3 THEN 1 ELSE 0 END + CASE WHEN heart_rate > 90 THEN 1 ELSE 0 END + CASE WHEN respiratory_rate > 20 OR paco2 < 4.25 THEN 1 ELSE 0 END + CASE WHEN white_blood_cell_count_wbc > 12000 OR white_blood_cell_count_wbc < 4000 OR immature_form > 10 THEN 1 ELSE 0 END + CASE WHEN systolic_blood_pressure_sbp < 90 OR mean_arterial_pressure_map < 65 THEN 1 ELSE 0 END + CASE WHEN mental_status = 1 OR oliguria = 1 THEN 1 ELSE 0 END) >= 2
SELECT * FROM "table_train_70" WHERE (CASE WHEN "temperature" < 36 OR "temperature" > 38.3 THEN 1 ELSE 0 END + CASE WHEN "heart_rate" > 90 THEN 1 ELSE 0 END + CASE WHEN "paco2" < 4.25 OR "respiratory_rate" > 20 THEN 1 ELSE 0 END + 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 "mean_arterial_pressure_map" < 65 OR "systolic_blood_pressure_sbp" < 90 THEN 1 ELSE 0 END + CASE WHEN "mental_status" = 1 OR "oliguria" = 1 THEN 1 ELSE 0 END) >= 2