Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Sales wants to see which customers lean heavily on one channel: every customer and channel pair with at least 8 completed orders.
Return customer_id, channel and completed_orders for every customer and channel pair with at least 8 completed orders. Sort by completed_orders from high to low, then by customer_id (lowest first), then by channel (A to Z).
Loading the Brightline dataset…
Language
Full plan
SQL ✓ · Excel and Power BI also included
Cancel anytime · 14-day full refund · Secure payment by Stripe