Can someone help me with these? Exercises Premiere Products Answer each of the f
ID: 3659072 • Letter: C
Question
Can someone help me with these?
Exercises
Premiere Products
Answer each of the following questionsusing the Premiere Products data shown in Figure 1-2.
No computer work is required.
1. List the names of all customers that have a credit limit of $7,500 or less.
2. List the order numbers for orders placed by customer number 608 on 10/23/2010.
3. List the part number, part description, and on-hand value for each part in item class SG.
(Hint: On-hand value is the result of multiplying the number of units on hand by the price.)
4. List the part number and part description of all parts that are in item class HW.
5. How many customers have a balance that exceeds their credit limit?
6. What is the part number, description, and price of the least expensive part in the database?
7. For each order, list the order number, order date, customer number, and customer name.
8. For each order placed on October 21, 2010, list the order number, customer number, and
customer name.
9. List the sales rep number and name for every sales rep who represents at least one customer
with a credit limit of $10,000.
10. For each order placed on October 21, 2010, list the order number, part number, part description,
and item class for each part ordered.
Explanation / Answer
Please rate it first with LifeSaver
1)
SELECT * FROM CUSTOMER WHERE CREDIT_LIMIT < = 7500
2)
SELECT * FROM ORDERS WHERE CUSTOMER_NUM=608 AND ORDER_DATE='10/23/2010'
3)
SELECT PART_NUM,DESCRIPTION,ON_HAND FROM PART WHERE CLASS='SG'
4)
SELECT PART_NUM,DESCRIPTION FROM PART WHERE CLASS='HW'
5)
SELECT COUNT(*) FROM CUSTOMER WHERE BALANCE>CREDIT_LIMIT
6)
SELECT PART_NUM,DESCRIPTION,PRICE FROM PART WHERE PRICE IN ( SELECT MIN(PRICE) FROM PART)
7)
SELECT O.ORDER_NUM,O.ORDER_DATE,O.CUSTOMER_NUM ,C.CUSTOMER_NAME FROM ORDERS O, CUSTOMER C WHERE O.CUSTOMER_NUM=C.CUSTOMER_NUM
8)
SELECT O.ORDER_NUM,O.CUSTOMER_NUM ,C.CUSTOMER_NAME FROM ORDERS O, CUSTOMER C WHERE O.CUSTOMER_NUM=C.CUSTOMER_NUM AND 0.ORDER_DATE='10/21/2010'
9)
SELECT R.REP_NUM, R.FIRST_NAME, R.LAST_NAME FROM CUST0MER C, REP R WHERE R.REP_NUM=C.REP_NUM AND C.CREDIT_LIMIT>10000
10)
SELECT O.ORDER_NUM,P.PART_NUM,P.DESCRIPTION,P.CLAS FROM ORDER 0, PART P, ORDER_LINE OL WHERE O.ORDER_NUM=OL.ORDER_NUM AND OL.PART_NUM=P.PART_NUM O.ORDER_DATE='10/21/2010'