/* 6. For each order list the following:. (Sort the list by customer, order description, order date) a. Customer name b. Order id c. Order Description (pickup or delivery) d. Order date */

/*7. How many delivery orders did we make? */

--8. Create a list of ingredients and the number of times that each ingredient -- was used on a pizza. Put the ingredient used most at the top of the list.

--9. Create a list of customers that have placed more than 20 orders. --Sort the list so the customer with the most orders appears at the top.

--10. What is the date of the first and last order taken?

/* 11. Add the following new customer. a. Cust_ID: 9999 b. Name: Ben Forta c. Phone: 555-9999 */

/*12. Customer 9999 has decided to have his pizza delivered and gave us the following address a. Street: 456 Main Street b. City: Anoka c. State: MN d. ZipCode: 55303 */

CUSTOMER Orderingredients Orders Pizzalngredients CustID Orderid + PK EK Orderid ... > PK IngrediD FirstName FK Ingredienti Order Date IngredDesc Last Name Order Time Street Order Type DeliveryTime PK City PK Order Type OrderType CustID State OrderType Order Desc Phone Number SizeID PizzaCrust ZipCode Crustid >0 # PK CrustID CrustType Delivery Area PizzaSize LPK Zip Code HPK SizelD CityName SizeDesc attribute name CUSTOMER Orderingredients Orders Pizzalngredients CustID Orderid + PK EK Orderid ... > PK IngrediD FirstName FK Ingredienti Order Date IngredDesc Last Name Order Time Street Order Type DeliveryTime PK City PK Order Type OrderType CustID State OrderType Order Desc Phone Number SizeID PizzaCrust ZipCode Crustid >0 # PK CrustID CrustType Delivery Area PizzaSize LPK Zip Code HPK SizelD CityName SizeDesc attribute name