Count how many orders were shared between customers, Sql Server

Count how many orders were shared between customers

Language: Layout:

View schema
Execution time: 0,02 sec, rows selected: 8, rows affected: 7, absolute service time: 0,17 sec

edit mode | history

  
CustomerId
CustomerId
SharedOrders

1
C1
C2
0

2
C1
C3
2

3
C2
C3
0

4
C1
C4
0

5
C2
C4
1

6
C3
C4
0


  
CustomerId
CustomerId
SharedOrders

1
C1
C3
2

2
C2
C4
1

λ

                                      .NET NoSQL database for rapid development