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 year-to-date revenue per region for the monthly review. Marcus Hill points out that all four regions show the same year-to-date figure in January, which can't be right.
AI assistant: “I calculated monthly revenue per region and added a running total with SUM() OVER, ordered by month.”
Run the AI query, then fix it so it returns region, month (1 to 12), revenue and revenue_ytd (that region's running total from January up to and including the month), both 2 decimals, completed orders only.
Loading the Brightline dataset…
Language
Full plan
SQL ✓ · Excel and Power BI also included
Cancel anytime · 14-day full refund · Secure payment by Stripe