Orders Stuck Unshipped
Medium
Order Fulfillment Pipeline
Today is 2026-05-10. Return orders that are still not shipped and were placed more than 3 days ago, with their age in days. Order by id.
Table schema
Orders(id INT PRIMARY KEY, ordered_at DATE, shipped_at DATE, delivered_at DATE)Sample data
id | ordered_at | shipped_at | delivered_at
1 | 2026-05-01 | 2026-05-02 | 2026-05-05
2 | 2026-05-02 | 2026-05-06 | 2026-05-12
3 | 2026-05-03 | 2026-05-04 | NULL
4 | 2026-05-04 | NULL | NULL
5 | 2026-05-08 | NULL | NULL
Discussion
No discussions yet.
Shalyam Support
Hi! Ask us anything — we'll reply on WhatsApp or Telegram within 24 hours.