Write SQL and Python, run instantly in your browser, and track your progress.
Customer support needs a list of active shipments that are still in transit and have not yet been delivered. Provide the shipment identifier, related order, status, and expected delivery date. Sort by the earliest expected delivery date first; break ties by the smallest identifier. Already delivered shipments are out of scope.
| Column Name | Type |
|---|---|
| shipment_id | INTEGER |
| order_id | INTEGER |
| warehouse_code | TEXT |
| carrier_name | TEXT |
Customer support needs a list of active shipments that are still in transit and have not yet been delivered. Provide the shipment identifier, related order, status, and expected delivery date. Sort by the earliest expected delivery date first; break ties by the smallest identifier. Already delivered shipments are out of scope.
| Column Name | Type |
|---|---|
| shipment_id | INTEGER |
| order_id | INTEGER |
| warehouse_code | TEXT |
| carrier_name | TEXT |
| service_level | TEXT |
| service_level | TEXT |
| tracking_number | TEXT |
| tracking_number | TEXT |
| ship_date | TEXT |
| ship_date | TEXT |
| est_delivery_date | TEXT |
| est_delivery_date | TEXT |
| delivery_date | TEXT |
| delivery_date | TEXT |
| status | TEXT |
| status | TEXT |
| weight_kg | REAL |
| weight_kg | REAL |
| shipping_fee_charged | REAL |
| shipping_fee_charged | REAL |
| shipment_id | order_id | warehouse_code | carrier_name | service_level | tracking_number | ship_date | est_delivery_date | delivery_date | status | weight_kg | shipping_fee_charged |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2 |
| shipment_id | order_id | warehouse_code | carrier_name | service_level | tracking_number | ship_date | est_delivery_date | delivery_date | status | weight_kg | shipping_fee_charged |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2 |
| shipment_id | order_id | status | est_delivery_date |
|---|---|---|---|
| 52 | 64 | in_transit | 2024-09-07 |
| 18 | 22 | in_transit | 2024-09-16 |
| 59 | 71 | in_transit | 2024-11-25 |
| 6 | 7 | in_transit | 2024-12-24 |
| shipment_id | order_id | status | est_delivery_date |
|---|---|---|---|
| 52 | 64 | in_transit | 2024-09-07 |
| 18 | 22 | in_transit | 2024-09-16 |
| 59 | 71 | in_transit | 2024-11-25 |
| 6 | 7 | in_transit | 2024-12-24 |
10 rows returned.
10 rows returned.
1. Output Columns:
2. Filtering:
3. Ordering:
1. Output Columns:
2. Filtering:
3. Ordering:
| W3-Atlanta |
| W3-Atlanta |
| UPS |
| UPS |
| economy |
| economy |
| TRK100002 |
| TRK100002 |
| 2025-02-25 |
| 2025-02-25 |
| 2025-03-04 |
| 2025-03-04 |
| 2025-03-05 |
| 2025-03-05 |
| delivered |
| delivered |
| 3.04 |
| 3.04 |
| 5.99 |
| 5.99 |
| 2 | 3 | W4-Dallas | USPS | expedited | TRK100003 | 2025-02-15 | 2025-02-18 | in_transit | 9.2 | 14.99 |
| 2 | 3 | W4-Dallas | USPS | expedited | TRK100003 | 2025-02-15 | 2025-02-18 | in_transit | 9.2 | 14.99 |
| 3 | 4 | W2-Chicago | USPS | standard | TRK100004 | 2025-02-07 | 2025-02-12 | picked_up | 7.17 | 5.0 |
| 3 | 4 | W2-Chicago | USPS | standard | TRK100004 | 2025-02-07 | 2025-02-12 | picked_up | 7.17 | 5.0 |
| 4 | 5 | W3-Atlanta | UPS | standard | TRK100005 | 2025-06-26 | 2025-07-01 | return_to_sender | 6.35 | 5.0 |
| 4 | 5 | W3-Atlanta | UPS | standard | TRK100005 | 2025-06-26 | 2025-07-01 | return_to_sender | 6.35 | 5.0 |
| 5 | 6 | W3-Atlanta | UPS | standard | TRK100006 | 2025-04-08 | 2025-04-13 | 2025-04-12 | delivered | 4.66 | 9.99 |
| 5 | 6 | W3-Atlanta | UPS | standard | TRK100006 | 2025-04-08 | 2025-04-13 | 2025-04-12 | delivered | 4.66 | 9.99 |
| 27 | 33 | in_transit | 2025-01-01 |
| 27 | 33 | in_transit | 2025-01-01 |