A data request just landed on Stripe's finance team: the board meeting is tomorrow and they need total payment volume reported today. Using the orders table, return the total sum of all order amounts as total_revenue.
orders
| column | type |
|---|---|
| id | INTEGER |
| customer_id | INTEGER |
| amount | NUMERIC |
| created_at | DATE |
| id | customer_id | amount | created_at |
|---|---|---|---|
| 1 | 1 | 120.00 | 2024-01-05 |
| 2 | 2 | 45.50 | 2024-01-18 |
| 3 | 1 | 300.00 | 2024-02-03 |
| 4 | 3 | 75.00 | 2024-02-20 |
| total_revenue |
|---|
| 540.50 |
All four order amounts are summed: 120.00 + 45.50 + 300.00 + 75.00 = 540.50.