By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| CUST_ID | ORDER_ID |
|---|---|
| 12455 | 4070 |
| 12454 | 4070 |
| 12454 | 4077 |
| 12455 | 4077 |
| 12454 | 2659 |
| 12455 | 1928 |
| 12454 | 2012 |
| 12453 | 1354 |
| 90000 | 91000 |
| 90000 | 91000 |
| order_id | cust_id1 | cust_id2 | cnt |
|---|---|---|---|
| 4070 | 12454 | 12455 | 2 |
| 4077 | 12454 | 12455 | 2 |