Write SQL and Python, run instantly in your browser, and track your progress.
You are a Logistics Analyst at Amazon. The operations team is conducting a review of recent shipping performance and needs a comprehensive list of all delivered shipments. This data will help identify delivery patterns and assess carrier performance.
Your task is to provide a list of delivered shipments showing when they were shipped and delivered, sorted from most recent delivery to oldest.
| Column Name | Type |
|---|---|
| shipment_id | INTEGER |
| order_id | INTEGER |
| warehouse_code | TEXT |
You are a Logistics Analyst at Amazon. The operations team is conducting a review of recent shipping performance and needs a comprehensive list of all delivered shipments. This data will help identify delivery patterns and assess carrier performance.
Your task is to provide a list of delivered shipments showing when they were shipped and delivered, sorted from most recent delivery to oldest.
| Column Name | Type |
|---|---|
| shipment_id | INTEGER |
| order_id | INTEGER |
| warehouse_code | TEXT |
| carrier_name | 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 | ship_date | delivery_date | status |
|---|---|---|---|---|
| 12 | 15 | 2025-08-21 | 2025-08-25 | delivered |
| 13 | 16 | 2025-07-22 | 2025-07-24 | delivered |
| 9 | 11 | 2025-06-28 | 2025-06-28 | delivered |
| shipment_id | order_id | ship_date | delivery_date | status |
|---|---|---|---|---|
| 12 | 15 | 2025-08-21 | 2025-08-25 | delivered |
| 13 | 16 | 2025-07-22 | 2025-07-24 | delivered |
| 9 | 11 | 2025-06-28 | 2025-06-28 | delivered |
Showing first 5 of 27 rows. Delivered shipments sorted by most recent delivery date.
Showing first 5 of 27 rows. Delivered shipments sorted by most recent delivery date.
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 |
| 47 | 58 | 2025-05-09 | 2025-05-11 | delivered |
| 47 | 58 | 2025-05-09 | 2025-05-11 | delivered |
| 53 | 65 | 2025-04-19 | 2025-04-22 | delivered |
| 53 | 65 | 2025-04-19 | 2025-04-22 | delivered |