Cold Case~59min

The Enterprise Deal That Was Never Actually Signed

DEAL-BIGCO is marked closed_won for 500,000 and its revenue was recognized — but contract_status has been stuck at "sent" the whole time, never countersigned. The actual cash received was only 15,000, and that amount exactly matches a small, separate add-on purchase order — not the big deal. 6 other closed_won deals also show contract_status "sent," but each has a cash receipt that exactly matches its deal amount, signed through a different e-signature system.

Tables you'll query

dealspaymentspurchase_orders

What you'll learn

JOINsSubqueriesAggregations & GROUP BY
Investigate this case →