Second Order of Each Customer

Return every customer's second order by date (id, customer_id, order_date). Customers with fewer than two orders are not returned. Order by customer_id.

Table schema

Orders(id INT PRIMARY KEY, customer_id INT, order_date DATE)

Sample data

id | customer_id | order_date
1 | 1 | 2026-01-01
2 | 1 | 2026-02-01
3 | 2 | 2026-01-15
4 | 1 | 2026-03-01