Your team wants to identify repeat buyers for a follow-up campaign. Using the orders table, find every customer who has placed more than one order — return their customer_id and order_count, sorted from most to fewest orders.
orders
| column | type |
|---|---|
| id | INTEGER |
| customer_id | INTEGER |
| amount | NUMERIC |
| id | customer_id | amount |
|---|---|---|
| 1 | 1 | 99.99 |
| 2 | 1 | 49.50 |
| 3 | 2 | 200.00 |
| 4 | 1 | 75.00 |
| 5 | 3 | 30.00 |
| 6 | 3 | 120.00 |
| customer_id | order_count |
|---|---|
| 1 | 3 |
| 3 | 2 |
Customer 1 placed 3 orders and customer 3 placed 2 — both qualify. Customer 2 placed only 1 order and is excluded.