Routine~12min

The Reviewer Who Never Bought

27 product reviews were left by customers who never purchased that product. The review platform was open to any registered user — not gated to verified buyers — allowing fake or competitor accounts to flood products with 1-star reviews. CUST-R099 reviewed before buying (order came later) — technically no prior purchase but they did eventually buy.

Tables you'll query

productsordersreviews

What you'll learn

JOINsAggregations & GROUP BY
Investigate this case →