1. List the names of all customers that have a credit limit less than $10,000. 2. List...

Question:

1. List the names of all customers that have a credit limit less than $10,000.

2. List the descriptions of all parts in item class AP and located in warehouse number 3.

3. List the order numbers for orders placed by customer number 608 on October 23, 2013.

4. List the part number, part description, and on-hand value (OnHand * Price) for each part in item class SG.

5. List the name of each customer that placed an order for two different parts in the same order.

6. List the name of each customer that has a credit limit of $5,000 and is represented by Richard Hull.

7. Find the sum of the balances for all customers represented by Juan Perez.

8. For each order, list the order number, order date, customer number, and customer name.

9. For each order placed on October 21, 2013, list the order number, order date, customer number, and customer name.

10. For each order placed on October 20, 2013, list the order number and customer name, along with the name of the rep who represents the customer.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Concepts of Database Management

ISBN: 978-111182591

7th edition

Authors: Philip J. Pratt, Joseph J. Adamski

Question Posted: