Skip to main content
Admissions guidance, study banks, and career tools — get started on Shalyam

Orders Stuck Unshipped

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.

Rewards · v2.1

Get Exclusive Insights with Every Issue

Join Shalyam Newsletter

Stay ahead in education, research, and innovation—straight to your inbox.