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.
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.