1. List the number and name of all sales reps. 2. List all information from the Part...

Question:

1. List the number and name of all sales reps.

2. List all information from the Part table for part FD21.

3. List the order number, order date, customer number, and customer name for each order.

4. List the order number, order date, customer number, and customer name for each order placed by any customer represented by the sales rep whose last name is Kaiser.

5. List the number and date of all orders that were placed on 10/20/2013 or that were placed by a customer whose rep number is 20.

6. List the number and date of all orders that were placed on 10/20/2013 by a customer whose rep number is 20.

7. List the number and date of all orders that were placed on 10/20/2013 but not by a customer whose rep number is 20.

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: