Routine~12min

The Wrong Region Deal

Sales commission and quota are calculated per territory. Fourteen closed deals are assigned to reps whose home region doesn't match the deal's region — quota is being credited to the wrong territory. REP-007 is a national account manager with region=ALL; their cross-region deals are always valid and should be excluded.

Tables you'll query

repsdeals

What you'll learn

JOINsSELECT & Filtering
Investigate this case →