Wayfair
Analytics Reporting Track · Medium · 25 min
Carrier Late Shipment Rate
Operations wants to compare carrier reliability for June 2024 shipments. Return each carrier_name, total_shipments, and the late_shipment_pct rounded to two ...
Company labels are directional practice context, not official interview guidance.
Objective
Practice query basics through a Wayfair-tagged business scenario.
Approach
Use this track to train on SQL that mirrors day-to-day analytics workflows and recurring reporting asks.
Company context
Company labels are directional practice context, not official interview guidance.
Operations wants to compare carrier reliability for June 2024 shipments. Return each carrier_name, total_shipments, and the late_shipment_pct rounded to two decimals, where a shipment is late if delivered_date is after promised_date. Sort by carrier_name.
shipments
| shipment_id | carrier_name | ||
|---|---|---|---|
| 1 | BlueLine | 2024-06-03 | 2024-06-03 |
| 2 | BlueLine | 2024-06-05 | 2024-06-07 |
| 3 | ParcelPro | 2024-06-06 | 2024-06-06 |
| 4 | ParcelPro | 2024-06-09 | 2024-06-12 |
| 5 | ParcelPro | 2024-06-10 | 2024-06-11 |
| 6 | SwiftFreight | 2024-06-12 | 2024-06-12 |
SQL workspace
Run queries against the protected question data, then submit once the result shape looks right.
Sign in to run SQL
Create a free account or sign in before running queries against protected question data.