Get intersection in between grouped data on sql in performative way : In my case there is a table called ServiceCarrier as below link.
<https://i.stack.imgur.com/GIMpi.png>

I want to group it by carrier Id and want to get the intersection in between grouped ones
Appreciate your help in advance