CREATE TABLE table_train_143 ("id" NUMBER, "gender" CLOB, "systolic_blood_pressure_sbp" NUMBER, "agitation" BOOLEAN, "npi" NUMBER, "aggression_domain" BOOLEAN, "delusions_hallucinations" BOOLEAN, "pulse_rate" NUMBER, "fridericia_corrected_qt_interval_qtcf" NUMBER, "diastolic_blood_pressure_dbp" NUMBER, "liver_disease" BOOLEAN, "hallucinations" BOOLEAN, "kidney_disease" BOOLEAN, "delusions" BOOLEAN, "respiratory_rate" NUMBER, "psychosis_subscale" BOOLEAN, "NOUSE" FLOAT)

have an npi score of >= 4 on either individual item ( delusions or hallucinations ) or >= 6 on the psychosis subscale ( combined delusions and hallucinations ) , or an npi score of >= 4 on agitation / aggression domain
SELECT * FROM table_train_143 WHERE (npi >= 4 AND (delusions = 1 OR hallucinations = 1)) OR (npi >= 6 AND psychosis_subscale = 1 AND delusions_hallucinations = 1) OR (npi >= 4 AND agitation = 1 OR aggression_domain = 1)
SELECT * FROM "table_train_143" WHERE "aggression_domain" = 1 OR ("agitation" = 1 AND "npi" >= 4) OR ("delusions_hallucinations" = 1 AND "npi" >= 6 AND "psychosis_subscale" = 1) OR (("delusions" = 1 OR "hallucinations" = 1) AND "npi" >= 4)