sql server - TSQL Query - how to get WHERE conditions to "add up"?

Question

EDIT3:

I have the following table:

item	In-House Manufacturing	Purchasing	Outsourcing
A	0	1	0
B	1	0	0
C	0	0	1
D	1	1	0
E	0	1	1

Answer 1

Simply ADD the values of the n columsn and verify if the addition is >= 1