Stripe's CFO might want to know the sum of all orders before a board meeting, possibly to compare it to last month's number. 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 |