1. List the number and name of all customers. 2. List the complete Part table. 3. List...

Question:

1. List the number and name of all customers.

2. List the complete Part table.

3. List the number and name of every customer represented by sales rep 35.

4. List the number and name of all customers that are represented by sales rep 35 and that have credit limits of $10,000.

5. List the number and name of all customers that are represented by sales rep 35 or that have credit limits of $10,000.

6. For each order, list the order number, order date, number of the customer that placed the order, and name of the customer that placed the order.

7. List the number and name of all customers represented by Juan Perez.

8. How many orders were placed on 10/20/2013?

9. Find the total of the balances for all customers represented by sales rep 35.

10. Give the part number, description, and on-hand value (OnHand * Price) for each part in item class HW.

11. List all columns and all rows in the Part table. Sort the results by part description.

12. List all columns and all rows in the Part table. Sort the results by part number within item class.

13. List the item class and the sum of the number of units on hand. Group the results by item class.

14. Create a new table named SportingGoods to contain the columns PartNum, Description, OnHand, Warehouse, and Price for all rows in which the item class is SG.

15. In the SportingGoods table, change the description of part BV06 to “Fitness Gym.”

16. In the SportingGoods table, delete every row in which the price is greater than $1,000.

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: