I need help with 4 questions in Oracle, SQL lab.

Tables with their columns are in the end.

Thank you very much for help!

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

1. For each customer that has placed an order, list each:

The company name

The item Description

The manufacturer

The quantity ordered

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. a) How many orders were shipped between December 25, 1999 and

January 5, 2000

B) List all orders with a shipping date of January 8, 2000

Include

1) The Order Number

2) Order Date

3) Customer company name

4) Shipping Date.

Order by

Customer Company Name and Order Number.

3. How many customers have not placed an order?

4.

List all customers

I) Who are ordering equipment with a description that contains ball.

II) Include-

1) Customer number,

2) Stock number, and

3) Description.

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

Table structures

Table: CUSTOMER

Columns: customer_num, fname, lname, company, address1, address2, city, state, zipcode, phone, newcolumn

Table: ITEMS

columns: item_num, order_num, stock_num, manu_code, quantity, total_price

Table: MANUFACT

Columns: manu_code, manu_name

Table: ORDERS

columns: order_num, order_date, customer_num, ship_instruct, backlog, po_num, ship_date, ship_weight, ship_charge, paid_date

Table: STOCK

columns: stock_num, manu_code, description, unit_price, unit, unit_descr