Growth analytics wants to know when each customer made their first purchase. Using the orders table, return each customer_id and their first_purchase date, ordered chronologically.
orders
| column | type |
|---|---|
| id | INTEGER |
| customer_id | INTEGER |
| amount | NUMERIC |
| created_at | DATE |
| id | customer_id | amount | created_at |
|---|---|---|---|
| 1 | 2 | 50.00 | 2024-01-05 |
| 2 | 1 | 99.99 | 2024-01-10 |
| 3 | 3 | 200.00 | 2024-02-01 |
| 4 | 1 | 49.50 | 2024-02-15 |
| 5 | 2 | 75.00 | 2024-03-20 |
| customer_id | first_purchase |
|---|---|
| 2 | 2024-01-05 |
| 1 | 2024-01-10 |
| 3 | 2024-02-01 |