The sales team wants to spotlight top-performing products. Using the sales table, find every product whose total revenue exceeds $1,000 — return product and total_revenue, sorted from highest to lowest revenue.
sales
| column | type |
|---|---|
| id | INTEGER |
| product | TEXT |
| revenue | NUMERIC |
| id | product | revenue |
|---|---|---|
| 1 | Widget A | 400.00 |
| 2 | Widget B | 200.00 |
| 3 | Widget A | 700.00 |
| 4 | Widget C | 150.00 |
| 5 | Widget B | 900.00 |
| 6 | Widget C | 50.00 |
| product | total_revenue |
|---|---|
| Widget A | 1100.00 |
| Widget B | 1100.00 |
Widget A: 400 + 700 = 1100. Widget B: 200 + 900 = 1100. Both exceed $1,000. Widget C: 150 + 50 = 200 — below the threshold and excluded.