The Refund Agent will not refund until the carrier confirms the return. The Shipping Agent will not create a return label until the refund is approved.
A deep-dive into non-SARGable SQL with B-tree diagrams, real EXPLAIN output, and the exact rewrites — told through a gaming dashboard that went from 4,200ms to 2ms without touching the schema.