Easy
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?
Author: Vincent CotroStatus: PublishedQuestion passed 2157 times
Edit
6
Community EvaluationsNo one has reviewed this question yet, be the first!
15
Update a column in an SQL table15
Select only distinct values in a column using SQL31
Write a SQL query to retrieve the list of employees with a salary greater than 5100.10
Write a SQL query to retrieve the products with a price less than 1000 and sort the results in descending order of price.12
Write a SQL query to insert data into a table12
Which SQL keyword is used to sort the result of a SELECT statement?10
Write the SQL query to delete a column from a table