Group By Count records in SQL Server

Hi,

I have 3 order which each order has 3 services.

I want to count the service that Family = Mercury as 1 not 3 as they are under the same order.

How can i do it under SQL Server?

Order : 12345

Service (Family) : Service1(Mercury) , service2(Mercury),

service3(Mercury)

order : 18999

Service(Family) : Service4(Mercury) , service5(Mercury),

service6(Mercury)

order : 20000

Service(Family) : Service4(Sunny) , service5(Sunny),

service6(Sunny)