Customers Shared Across Sales Representatives

Find canonical pairs of active sales representatives who currently share at least two distinct customers. Duplicate assignment history must not inflate the count. Return rep_a, rep_b and shared_customers. Return columns: rep_a, rep_b, shared_customers.

Preparing the interactive SQL workspace...

Challenge overview

What you will practice

Find canonical pairs of active sales representatives who currently share at least two distinct customers. Duplicate assignment history must not inflate the count. Return rep_a, rep_b and shared_customers. Return columns: rep_a, rep_b, shared_customers.

Difficulty: Advanced
SQL concept: INNER JOIN