Routine~14min

The Serial Returner

One customer placed 23 orders over four months and returned 21 of them for full refunds. They always return on day 27-29 of the 30-day window. Near-zero net revenue, 91% return rate.

Tables you'll query

customersordersreturns

What you'll learn

Aggregations & GROUP BYJOINs
Investigate this case →