Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Your manager asked the AI assistant which customers spent more than 6,000 in completed orders this year. It says there are none, but Harbor & Pine Hotels alone buys far more than that.
AI assistant: “I filtered for revenue over 6,000 and grouped by customer. No customer passes that threshold.”
Run the AI query, then fix it so it returns customer_name and total completed revenue (2 decimals) for every customer whose total is over 6,000.
Loading the Brightline dataset…
Language
Full plan
SQL ✓ · Excel and Power BI also included
Cancel anytime · 14-day full refund · Secure payment by Stripe