Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Merchandising asked the AI assistant how many products each category has and how many units they sold on completed orders. It says every category has hundreds of products, but the whole catalog has 24.
AI assistant: “I joined products to their order lines and orders, kept completed orders, then counted products and summed units per category.”
Run the AI query, then fix it so it returns category, products (the number of different products in the category) and units (total quantity on completed orders), one row per category.
Loading the Brightline dataset…
Language
Full plan
SQL ✓ · Excel and Power BI also included
Cancel anytime · 14-day full refund · Secure payment by Stripe