First Order of Each Customer

Return the first (earliest) order of every customer with its id, customer_id, order_date and amount. Order by customer_id.

Table schema

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

Sample data

id | customer_id | order_date | amount
1 | 1 | 2026-01-05 | 100
2 | 1 | 2026-01-10 | 200
3 | 2 | 2026-01-03 | 50
4 | 2 | 2026-01-04 | 75