1. (10 Points) For each customer, list each stock item ordered, the manufacturer, the quantity ordered, and the total price paid. Include the following columns in the order given below:

From Customer Table: Company

From Stock Table: Description

From the Manufact Table: Manu_Name

From the Items Table: Quantity, Total Price

Order the output by Company and Description.

2. (10 Points) List all orders with a shipping date between December 25, 1999 and January 5, 2000. List the Order Number, Order Date, Customer company name, and Shipping Date. Order by Customer Company Name and Order Number.

3. (10 Points) Count the number of customers who do not have any orders placed.

4. (10 Points) List all customers who are ordering equipment whose description begins with tennis or volleyball. List the Customer number, Stock number, and Description. Do not repeat any rows.

------------------------

SQL> Describe stores.customer; Name Null? Type ----------------------------------------------------- -------- ------------------------------------ CUSTOMER_NUM NOT NULL NUMBER(3) FNAME VARCHAR2(15) LNAME VARCHAR2(15) COMPANY VARCHAR2(20) ADDRESS1 VARCHAR2(20) ADDRESS2 VARCHAR2(20) CITY VARCHAR2(15) STATE CHAR(2) ZIPCODE CHAR(5) PHONE VARCHAR2(18)

SQL> Describe stores.orders; Name Null? Type ----------------------------------------------------- -------- ------------------------------------ ORDER_NUM NOT NULL NUMBER(4) ORDER_DATE NOT NULL DATE CUSTOMER_NUM NUMBER(3) SHIP_INSTRUCT VARCHAR2(40) BACKLOG CHAR(1) PO_NUM VARCHAR2(10) SHIP_DATE DATE SHIP_WEIGHT NUMBER(8,2) SHIP_CHARGE NUMBER(6,2) PAID_DATE DATE

SQL> Describe Stores.Items; Name Null? Type ----------------------------------------------------- -------- ------------------------------------ ITEM_NUM NOT NULL NUMBER(2) ORDER_NUM NOT NULL NUMBER(4) STOCK_NUM NUMBER(2) MANU_CODE CHAR(3) QUANTITY NUMBER(3) TOTAL_PRICE NUMBER(8,2)

SQL> Describe Stores.stock; Name Null? Type ----------------------------------------------------- -------- ------------------------------------ STOCK_NUM NOT NULL NUMBER(2) MANU_CODE NOT NULL CHAR(3) DESCRIPTION VARCHAR2(15) UNIT_PRICE NUMBER(8,2) UNIT CHAR(4) UNIT_DESCR VARCHAR2(15)

SQL> Describe Stores.Manufact; Name Null? Type ----------------------------------------------------- -------- ------------------------------------ MANU_CODE NOT NULL CHAR(3) MANU_NAME VARCHAR2(15)

Q along with SQL database info.