Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Logistics asked the AI assistant for the average transit time per carrier for December shipments. ParcelLine looks quicker than it felt to customers waiting for parcels that hadn't arrived.
AI assistant: “I averaged shipped-to-delivered days per carrier for December shipments, using 0 where the delivery date is missing so no rows are lost.”
Run the AI query, then fix it so it returns carrier and avg_transit_days: the average days from shipped_date to delivered_date for shipments shipped on or after 2025-12-01, counting only shipments that have been delivered, rounded to 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