Using MySQL Workbench

1. Write a query to show the total money paid by each customer.
2. Write a query to show the total number of orders from each customer.
3. Write a query to show the total value of each order.
4. Write a query to show the number of staff in each office.

5. customerNumber	int PK
   customerName	varchar(255)
   contactLastName	varchar(255)
   contactFirstName	varchar(255)
   phone	varchar(255)
   addressLine1	varchar(255)
   addressLine2	varchar(255)
   city	varchar(255)
   state	varchar(255)
   postalCode	varchar(255)
   country	varchar(255)
   salesRepEmployeeNumber	int
   creditLimit

6. employeeNumber	int PK
   lastName	text
   firstName	text
   extension	text
   email	text
   officeCode	int
   reportsTo	text
   jobTitle	text

   ID	int AI PK
   orderNumber	int
   productCode	varchar(10)
   quantityOrdered	int
   priceEach	double
   orderLineNumber	int

   orderNumber	int PK
   orderDate	date
   requiredDate	date
   shippedDate	date
   status	text
   comments	text
   customerNumber	int

   productLine	varchar(255) PK
   textDescription	text
   htmlDescription	text
   image	text

   productCode	varchar(10) PK
   productName	text
   productLine	varchar(255)
   productScale	text
   productVendor	text
   productDescription	text
   quantityInStock	int
   buyPrice	double
   MSRP	double