CREATE TABLE table_train_19 ("id" INT, "white_blood_cell_count_wbc" INT, "active_infection" BOOLEAN, "heart_disease" BOOLEAN, "temperature" FLOAT, "skin_lesion" BOOLEAN, "heart_rate" INT, "paco2" FLOAT, "immature_form" INT, "respiratory_rate" INT, "age" FLOAT, "NOUSE" FLOAT)

2 or more among 1 ) 4 ) 1 ) body temperature > 38 c or < 36 c 2 ) heart rate > 90 / min 3 ) respiratory rate > 20 / min or paco2 < 32 mmhg 4 ) wbc > 12000 / mm3, < 4000 / mm3, or band forms > 10 % ;
SELECT * FROM table_train_19 WHERE (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 white_blood_cell_count_wbc > 12000 OR white_blood_cell_count_wbc < 4000 OR immature_form > 10 THEN 1 ELSE 0 END) >= 2
SELECT * FROM "table_train_19" WHERE (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 "white_blood_cell_count_wbc" < 4000 OR "white_blood_cell_count_wbc" > 12000 THEN 1 ELSE 0 END) >= 2