Cold Case~61min

The Agent Charging Nearly Double The Standard Commission

Agent AGT-07 charges a 35% commission on his talent's domestic bookings — versus the agency-standard 20% rate every other agent applies to domestic work — quietly pocketing the extra 15% across 5 bookings worth $21,600.00 in gig fees, a $3,240.00 skim. Agent AGT-14 charges 25% too, but only on international bookings, which carry a documented, higher 25% agency-standard rate due to added logistics — matches policy exactly, not a markup.

Tables you'll query

agency_standard_ratestalentbookings

What you'll learn

JOINsAggregations & GROUP BYSubqueries
Investigate this case →