1. List the name of each client that placed an order two different tasks in the same order.
2. Find the sum of the balances for all customers represented by Christopher Turner.
3. For each order placed on September 10, 2018, list the order number (OrderNum), order date (OrderDate), client number (ClientNum) and client name (ClientName)
4. BITS needs to contact clients when problems arise concerning an order. What other attributes could BITS include in the Client table to assist contacting customers?

Leave a Reply

Your email address will not be published. Required fields are marked *