Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Pricing asked the AI assistant what share of each cleaning product's units were sold at a discount. It reports 100% for every product, which can't be right.
AI assistant: “I kept the discounted lines of the cleaning products (301 to 306) and worked out the discounted share of units for each one.”
Run the AI query, then fix it so it returns product_id and discounted_share_pct (units on discounted lines as a percentage of all of that product's units, 2 decimals) for products 301 to 306.
Loading the Brightline dataset…
Language
Full plan
SQL ✓ · Excel and Power BI also included
Cancel anytime · 14-day full refund · Secure payment by Stripe