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 Partner channel manager asked the AI assistant for the 10 most recent Partner orders that were refunded or cancelled. Its list includes Online and Sales Rep orders.
AI assistant: “I filtered to refunded or cancelled orders in the Partner channel, sorted newest first and kept the top 10.”
Run the AI query, then fix it so it returns order_id, order_date, status and channel for the 10 most recent refunded or cancelled Partner orders, newest first (on the same date, higher order_id first).
Loading the Brightline dataset…
Language
Full plan
SQL ✓ · Excel and Power BI also included
Cancel anytime · 14-day full refund · Secure payment by Stripe