Computer Science
Below are the customer and order tables :
Customers
| customer id (PK) |
|---|
| first_name |
| last_name |
| address |
| city |
| state |
| zip |
Orders
| order id (PK) |
|---|
| order_date |
| amount |
| customer_id (FK) |
List the sum of the totals of orders grouped by customer and state.
SQL Joins & Grouping
1 Like
Answer
SELECT c.customer_id, c.state, SUM(o.amount) AS total_order_amount
FROM Customers c, orders o
WHERE c.customer_id = o.customer_id
GROUP BY c.customer_id, c.state;
Answered By
3 Likes
Related Questions
List the maximum salary of employee grouped by their department number.
Below are the customer and order tables :
Customers
customer id (PK) first_name last_name email address city state zip Orders
order id (PK) order_date amount customer_id (FK) List the total of customers' orders grouped by customer (id).
Below are the customer and order tables :
Customers
customer id (PK) first_name last_name email address city state zip Orders
order id (PK) order_date amount customer_id (FK) List the customers (name) and the total amount of all their orders.
Schemas of tables EMPL, Dept, SalaryGrade are being shown below :
EMPL (EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO) SALARYGRADE (Lowsal, Highsal, Grade) DEPT (Deptno, DeptName, Location)List the department names and the number of their employees.