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