Routine~13min

The Same IP Address

14 different customer accounts all placed their first order from the same IP address and all claimed the new-customer discount. Someone found a loophole.

Tables you'll query

customersorders

What you'll learn

Aggregations & GROUP BYSELECT & Filtering
Investigate this case →