Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
The Head of Sales, Grace Whitfield, asked the AI assistant for the team size of every manager. Its answer lists almost every rep, each with exactly one direct report.
AI assistant: “I joined sales_reps to itself to pair managers with their reports and counted the reports per manager.”
Run the AI query, then fix it so it returns manager_name and direct_reports (how many reps have that person as their manager) for everyone with at least one direct report.
Loading the Brightline dataset…
Language
Full plan
SQL ✓ · Excel and Power BI also included
Cancel anytime · 14-day full refund · Secure payment by Stripe