Thank you ALZDBA

Actually your solution is similar to

select Facility1 as [Facility 1]

,(select count(*) FROM MyTable WHERE Cond1) as [First Condition]

,(select count(*) FROM MyTable WHERE Cond2) as [Second Condition]

,(select count(*) FROM MyTable WHERE Cond3) as [Third Condition]

Now what about the 2nd row, how do I use carriage return and start the 2nd line for Facility2. I don't want to use a separate select statement for the 2nd Facility, so that my result appear like a table.