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