Complex~35min
The Loyal Fraudster
Return rate jumped from a ~6% baseline to 23% overall. The highest-volume returners have perfect review scores and years of purchase history. They don't look like fraudsters. Look harder.
Tables you'll query
ordersreturnscustomersreviews
What you'll learn
Window FunctionsSubqueriesCTEs (WITH clause)JOINsAggregations & GROUP BY