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 returns team asked the AI assistant for total and refunded orders per channel. Its refunded column equals the total, which would mean every order came back.
AI assistant: “I counted all orders per channel and, with a CASE, the refunded ones.”
Run the AI query, then fix it so it returns channel, orders (all orders) and refunded_orders (orders with status 'refunded'), one row per channel.
Loading the Brightline dataset…
Language
Full plan
SQL ✓ · Excel and Power BI also included
Cancel anytime · 14-day full refund · Secure payment by Stripe