• To elaborate on ALZDBA's solution a little to make it clear what he was proposing:

    select facilityname

    , sum(case when condition1 then 1 else 0 end ) as whatevernameyouwannegiveit

    , sum(case when condition2 then 1 else 0 end ) as whatevernameyouwannegiveit_theSecond

    , sum(case when condition2 then 1 else 0 end ) as whatevernameyouwannegiveit_theThird

    from yourobject

    group by facilityname

    If you compare the execution plan for this and your proposed subquery solution, you will see the huge difference is that this only scans the table once.