Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Daniel Ortiz asked the AI assistant to put West's monthly revenue for the second half of 2025 next to the same months of 2024. Its query returns no rows at all.
AI assistant: “I joined each West order line to last year's revenue for the same region and month, then summed this year's revenue per month.”
Run the AI query, then fix it so it returns month (7 to 12), revenue_2025 (completed West revenue, 2 decimals) and revenue_2024 (from revenue_2024), one row per month, sorted by month.
Loading the Brightline dataset…
Language
Full plan
SQL ✓ · Excel and Power BI also included
Cancel anytime · 14-day full refund · Secure payment by Stripe