Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
You asked the AI assistant for each region's share of completed revenue for the board pack. Marcus Hill noticed that the four shares add up to well under 100%.
AI assistant: “I summed completed revenue per region and divided it by total revenue, which I got from a subquery.”
Run the AI query, then fix it so it returns region, revenue and pct_of_total (the region's share of total completed revenue, in percent), both 2 decimals.
Loading the Brightline dataset…
Language
Full plan
SQL ✓ · Excel and Power BI also included
Cancel anytime · 14-day full refund · Secure payment by Stripe