NEED JUST THE COMMANDS FOR EACH PROBLEM
QUESTION 2
1. Premiere Products Database: Problem 2 (p.125)
QUESTION 3
1. Alexamara Marina Group Database: Problem 4 (p.127)
QUESTION 4
1. Alexamara Marina Group Database: Problem 7 (p.127)
QUESTION 5
1. Premiere Products Database: Problem 16 (p.125)
QUESTION 6
1. Henry Books Database: Problem 23 (p.126)
QUESTION 7
1. Premiere Products Database: Problem 1 (p.125)
QUESTION 8
1. Henry Books Database: Problem 9 (p.126)
QUESTION 9
1. Premiere Products Database: Problem 9 (p.125)
QUESTION 10
1. Alexamara Marina Group Database: Problem 14 (p.127)
QUESTION 11
1. Premiere Products Database: Problem 10 (p.125)
QUESTION 12
1. Henry Books Database: Problem 14 (p.126)
QUESTION 13
1. Premiere Products Database: Problem 4 (p.125)
QUESTION 14
1. Henry Books Database: Problem 11 (p.126)
QUESTION 15
1. Henry Books Database: Problem 19 (p.126)
QUESTION 16
1. Henry Books Database: Problem 4 (p.126)
QUESTION 17
1. Alexamara Marina Group Database: Problem 11 (p.127)
QUEsTION 18
1. Henry Books Database: Problem 13 (p.126)
QUESTION 19
1. Premiere Products Database: Problem 11 (p.125)
QUESTION 20
1. Alexamara Marina Group Database: Problem 3 (p.127)
PREMIERE PRODUCT QUESTIONS:
HENRY BOOKS QUESTIONS:
ALEXAMARA MARINA GROUP QUESTIONS:
USE CHARTS BELOW TO GENERATE COMMANDS PLEASE.
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
