Late Purchase Order Deliveries

Return po_id for every order received after its expected date. Order by po_id.

Table schema

PurchaseOrders(po_id INT PRIMARY KEY, supplier_id INT, order_date DATE, expected_date DATE, received_date DATE)

Sample data

PurchaseOrders
po_id | supplier_id | order_date | expected_date | received_date
1 | 1 | 2026-03-01 | 2026-03-10 | 2026-03-09
2 | 1 | 2026-03-05 | 2026-03-15 | 2026-03-18
3 | 2 | 2026-03-02 | 2026-03-12 | 2026-03-12
4 | 2 | 2026-03-20 | 2026-03-30 | NULL
5 | 3 | 2026-03-10 | 2026-03-25 | 2026-03-29
6 | 3 | 2026-03-11 | 2026-03-20 | NULL