HEY ; THANK YOU FOR LOOKING AT MY QUESTION! I AM JUST ASKING FOR THE COMMANDS SO I CAN EXECUTE VIA MY SQL FOR MY HOMEWORK PLEASE.
THE TABLES ARE AT THE BOTTOM SO THAT YOU HAVE THE RIGHT TABLE NAMES FOR THE COMMANDS.
THANK YOU AGAIN ;
QUESTION 1
1. Premiere Products Database: Problem 8 (p. 158)
QUESTION 2
1. Premiere Products Database: Problem 20 (p. 158)
QUESTION 3
1. Henry Books Database: Problem 3 (p. 159)
QUESTION 4
1. Alexamara Marina Group Database: Problem 14 (p. 160)
QUESTION 5
1. Premiere Products Database: Problem 7 (p. 158)
QUESTION 6
1. Henry Books Database: Problem 8 (p. 159)
QUESTION 7
1. Alexamara Marina Group Database: Problem 15 (p. 160)
QUESTION 8
1. Alexamara Marina Group Database: Problem 1 (p. 160)
QUESTION 9
1. Henry Books Database: Problem 12 (p. 159)
QUESTION 10
1. Henry Books Database: Problem 13 (p. 159)
QUESTION 11
1. Premiere Products Database: Problem 3 (p. 158)
QUESTION 12
1. Premiere Products Database: Problem 17 (p. 158)
QUESTION 13
1. Alexamara Marina Group Database: Problem 11 (p. 160)
QUESTION 14
1. Henry Books Database: Problem 11 (p. 159)
QUESTION 15
1. Premiere Products Database: Problem 16 (p. 158)
QUESTION 16
1. Premiere Products Database: Problem 10 (p. 158)
QUESTION 17
1. Premiere Products Database: Problem 15 (p. 158)
QUESTION 18
1. Alexamara Marina Group Database: Problem 4 (p. 160)
QUESTION 19
1. Alexamara Marina Group Database: Problem 7 (p. 160)
QUESTION 20
1. Henry Books Database: Problem 17 (p. 159)
TABLE NAMES ARE AS FOLLOWED;
Exercises Premiere Products and the Premiere Products database (see Figure 1-2 in Chapter 1) to complete the MySQlse Use the notes at the end of Chapter 3 to print your output if directed to do so Use by your instructor 125 List the part number, description, and price for all parts. 1. tall rows and columns for the complete ORDERS table. 2. List List the names of customers with credit limits of $7,500 or less. 3. order number for each order placed by customer number 148 on 10/20/2007.(Hint 4. List the If you need help, use the discussion of t he DATE data type in Figure 3-11 in Chapter 3.) the number and name of each customer represent 5. List . List the part number and part description of each part that is not in item class SG. . List the part number, description, and number of units on hand for each part that has ed by sales rep 35 or sales rep 65. between 10 and 25 units on hand, including both 10 and 25. Do this two ways. B. List the part number, part description, and on-hand value (units on hand unit price) of each part in item class AP. (On-hand value is really units on hand cost, but there is no COST col- umn in the PART table.) Assign the name ON HAND_VALUE to the computation. List the part number, part description, and on-hand value for each part whose on-hand value is at least $7,500. Assign the name ON_ HAND_VALUE to the computation. Use the IN operator to list the part number and part description of each part in item class AP or SG. 9. o. 11. Find the number and name of each customer whose name begins with the letter "K 12. List all details about all parts. Order the output by part description. 13. List all details about all parts. Order the output by part number within item class. (That is, order the output by item class and then by part number.) How many customers have balances that are more than their credit limits? Find the total of the balances for all customers represented by sales rep 65 with balances that are less than their credit limits 14. 15. 6. List the part number, part description, and on-hand value of each part whose number of units on hand is more than the average number of units on hand for all parts. (Hint: Use a subquery.) 7. What is the price of the most expensive part in the database? 8. What is the part number, description, and price of the most expensive part in the database? (Hint: Use a subquery.) List the sum of the balances of all customers for each sales rep. Order and group the results by sales rep number. List the sum of the balances of all customers for each sales rep, but restrict the output to hose sales reps for which the sum is more than $10,000. ist the part number of any part with an unknown description. Exercises Premiere Products and the Premiere Products database (see Figure 1-2 in Chapter 1) to complete the MySQlse Use the notes at the end of Chapter 3 to print your output if directed to do so Use by your instructor 125 List the part number, description, and price for all parts. 1. tall rows and columns for the complete ORDERS table. 2. List List the names of customers with credit limits of $7,500 or less. 3. order number for each order placed by customer number 148 on 10/20/2007.(Hint 4. List the If you need help, use the discussion of t he DATE data type in Figure 3-11 in Chapter 3.) the number and name of each customer represent 5. List . List the part number and part description of each part that is not in item class SG. . List the part number, description, and number of units on hand for each part that has ed by sales rep 35 or sales rep 65. between 10 and 25 units on hand, including both 10 and 25. Do this two ways. B. List the part number, part description, and on-hand value (units on hand unit price) of each part in item class AP. (On-hand value is really units on hand cost, but there is no COST col- umn in the PART table.) Assign the name ON HAND_VALUE to the computation. List the part number, part description, and on-hand value for each part whose on-hand value is at least $7,500. Assign the name ON_ HAND_VALUE to the computation. Use the IN operator to list the part number and part description of each part in item class AP or SG. 9. o. 11. Find the number and name of each customer whose name begins with the letter "K 12. List all details about all parts. Order the output by part description. 13. List all details about all parts. Order the output by part number within item class. (That is, order the output by item class and then by part number.) How many customers have balances that are more than their credit limits? Find the total of the balances for all customers represented by sales rep 65 with balances that are less than their credit limits 14. 15. 6. List the part number, part description, and on-hand value of each part whose number of units on hand is more than the average number of units on hand for all parts. (Hint: Use a subquery.) 7. What is the price of the most expensive part in the database? 8. What is the part number, description, and price of the most expensive part in the database? (Hint: Use a subquery.) List the sum of the balances of all customers for each sales rep. Order and group the results by sales rep number. List the sum of the balances of all customers for each sales rep, but restrict the output to hose sales reps for which the sum is more than $10,000. ist the part number of any part with an unknown description
