The first picture is for premier products, please try to use my sql with screen shots if possible thank you
Question 1 Henry Books Database: Problem 17 (p. 159)
QUESTION 9 Alexamara Marina Group Database: Problem 10 (p. 160)
QUESTION 10 Premiere Products Database: Problem 14 (p. 158)
QUESTION 11 Henry Books Database: Problem 10 (p. 159)
QUESTION 12 Henry Books Database: Problem 5 (p. 159)
QUESTION 13 Premiere Products Database: Problem 7 (p. 158)
QUESTION 14 Alexamara Marina Group Database: Problem 1 (p. 160)
QUESTION 15 Premiere Products Database: Problem 13 (p. 158)
QUESTION 16 Alexamara Marina Group Database: Problem 14 (p. 160)
QUESTION 17 Henry Books Database: Problem 11 (p. 159)
QUESTION 18 Premiere Products Database: Problem 3 (p. 158)
QUESTION 19 Henry Books Database: Problem 8 (p. 159)
QUESTION 20
Alexamara Marina Group Database: Problem 15 (p. 160)
5
00 Sprint 7:00 PM 5796 . 14,090 and name of the customer that placed the order For each order, list the order number, order date, part number quoted price for each order line that makes up the order Use the IN operator to find the number and name of each cus on October 21, 2007 2. For each order placed on October 21, 2007, list the order number a number of units crdered, and 3 customer that placed an 4. Exercise 4, but this time use the EXISTS operator in your 6. Find the number and name of each customer that did not place an order 7. For each order, list the order number, order date, part number 8. Repeat Exercise 7, but this time order the rows by item class and October 21, 2007. number, part description, and item class for each part that makes up the order then by order number 9. Use a subquery to find the rep number, last name, and first name of each sales t resents at least one customer with a credit limit of $5,000. List e the results. not use a subquery. Find the number and name of each customer that currently has an order on file or Gas Range. 11. 12. List the part number, part description, and item class for each pair of parts that are in the same item class. (For example, one such pair would be part AT94 and part FD21, because the item class for both parts is HW) 13. List the order number and order date for each order placed by the customer naned Johnson's Department Store. (Hint To enter an apostrophe (single quotation mark) within a string of characters, type two single quotation marks.) List the order number and order date for each order that contains an order ine for List the order number and order date for each order that either was placed by Johnsons Department Store or that contains an order line for a Gas Range. List the order number and order date for each order that was placed by Johnson's Department Store and that contains an order line for a Gas Range. 14. hon 15. 16. 17. List the order number and order date for each order that was placed by Johnsont Department Store but that does not contain an order line for a Gas Range. List the part number, part description, unit price, and item class for each part 18. that has a unt the ALL or AN 19. If you used ALL in Exercise 18, repeat the exercise using ANY. If you used ANkemand price greater than the unit price of every part in item class AP Use ether operator in your query. (Hint: Make sure you select the correct operator.) y, repeat te exercise using ALL, and then run the new command. What question does answer? his 20. For each part, ist the part number, description, units on hand, Orosa arts that ur d of units ordered. All parts should be included in the results.let rently not on order, the order number and number of units order the results by part number order number, and number ordered should be left blak 00 Sprint 7:00 PM 5796 . 14,090 and name of the customer that placed the order For each order, list the order number, order date, part number quoted price for each order line that makes up the order Use the IN operator to find the number and name of each cus on October 21, 2007 2. For each order placed on October 21, 2007, list the order number a number of units crdered, and 3 customer that placed an 4. Exercise 4, but this time use the EXISTS operator in your 6. Find the number and name of each customer that did not place an order 7. For each order, list the order number, order date, part number 8. Repeat Exercise 7, but this time order the rows by item class and October 21, 2007. number, part description, and item class for each part that makes up the order then by order number 9. Use a subquery to find the rep number, last name, and first name of each sales t resents at least one customer with a credit limit of $5,000. List e the results. not use a subquery. Find the number and name of each customer that currently has an order on file or Gas Range. 11. 12. List the part number, part description, and item class for each pair of parts that are in the same item class. (For example, one such pair would be part AT94 and part FD21, because the item class for both parts is HW) 13. List the order number and order date for each order placed by the customer naned Johnson's Department Store. (Hint To enter an apostrophe (single quotation mark) within a string of characters, type two single quotation marks.) List the order number and order date for each order that contains an order ine for List the order number and order date for each order that either was placed by Johnsons Department Store or that contains an order line for a Gas Range. List the order number and order date for each order that was placed by Johnson's Department Store and that contains an order line for a Gas Range. 14. hon 15. 16. 17. List the order number and order date for each order that was placed by Johnsont Department Store but that does not contain an order line for a Gas Range. List the part number, part description, unit price, and item class for each part 18. that has a unt the ALL or AN 19. If you used ALL in Exercise 18, repeat the exercise using ANY. If you used ANkemand price greater than the unit price of every part in item class AP Use ether operator in your query. (Hint: Make sure you select the correct operator.) y, repeat te exercise using ALL, and then run the new command. What question does answer? his 20. For each part, ist the part number, description, units on hand, Orosa arts that ur d of units ordered. All parts should be included in the results.let rently not on order, the order number and number of units order the results by part number order number, and number ordered should be left blak
