Hard
INNER JOIN
Pro Challenge

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