For the Database Course.

Write statements using NotePad

a. For each order, list the order number, orderdate, part number, part description, and item class for each part that makes up the order. The output shuold be sorted by class in descending order.

b. For each order, list the order number and order date along with the number and name of customer who placed the order.

c. LIst the order number along with the number and name of the customers who did not place an order on "October 23, 2007"

d. Create a view that consists of the number, name, address, balance, and credit limit of all customers with credit limits that are greater than or equal to $10,000.

e. Create a view that consists of the rep number, rep last name, rep first name, customer number, and customer name.