Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
The e-commerce team wants to thank customers who completed at least 8 Online orders. The AI assistant's list includes customers whose Online orders were partly cancelled or refunded.
AI assistant: “I grouped Online orders by customer and kept the customers with 8 or more.”
Run the AI query, then fix it so it returns customer_id and completed_orders (their completed Online orders) for customers with at least 8 of them.
Loading the Brightline dataset…
Language
Full plan
SQL ✓ · Excel and Power BI also included
Cancel anytime · 14-day full refund · Secure payment by Stripe