Routine~14min
The Duplicate Customer
The new-customer discount is being redeemed far more than acquisition numbers justify. Someone — or many someones — is claiming it multiple times. Find how.
Tables you'll query
customersdiscount_redemptionsorders
What you'll learn
String FunctionsAggregations & GROUP BYSELECT & Filtering