Write a SQL query to get the total order amount for each customer.

Question

Given the following 'orders' table:
```
| order_id | customer_id | order_date | total_amount |
|----------|-------------|------------|--------------|
| 1        | 1           | 2023-01-01 | 100          |
| 2        | 2           | 2023-01-02 | 150          |
| 3        | 1           | 2023-01-03 | 200          |
```
Which SQL query retrieves the total order amount for each customer?

Accepted Answer

SELECT customer_id, SUM(total_amount) FROM orders GROUP BY customer_id;

Answer

SELECT customer_id, COUNT(total_amount) FROM orders GROUP BY customer_id;

Answer

SELECT customer_id, AVG(total_amount) FROM orders GROUP BY customer_id;

Answer

SELECT customer_id, MAX(total_amount) FROM orders GROUP BY customer_id;

Question from the SQL - Fundamentals test

Write a SQL query to get the total order amount for each customer.