ALZDBA's solution works perfectly... (atleast for me)

select Facility,

sum(case when condition_1 then 1 else 0 end),

sum(case when condition2 then 1 else 0 end)

from Table

group by Facility

Solution would look like this:

Facility_1 Count(for_condition_1) Count(for_condition_2) ......