Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Module 5 Review Questions Exercises KimTax Pet Supplies 14. Ust the inwoice number and invoice date for each invoice that contains an inwoice line for
Module 5 Review Questions Exercises KimTax Pet Supplies 14. Ust the inwoice number and invoice date for each invoice that contains an inwoice line for a Wild Bird Food (25 p). 15. List the invoice number and invoice date for each invoice that eicher was created for James Gonzalez or that contains an invoice line for Wild Bird Food (25ib). 16. List the invoice number and invoice date for each invoice that was created for James Gonzalez and that contains an invoice line for Widd Bird Food (25ib). 17. List the invoice number and invoice date for each invoice that was created for James Gonzalez but that does not contain an invoice line for Widd Bird Food (2516). 18. List the item 10 , description, unit price, and category for each item that has a unit price greater than the unit price of every item in category CAT. Use either the ALL or ANY operator in vour query. (Hint: Make sure you select the correct operator.) 19. For each item, list the item 10 , description, units on hand, invoice number, and quantity ordered. All items should be induded in the results. For those items that are currently not on an invoice, the invoice number and quantity ordered should be left blank. Order the results bv item iD. Hiticar Thiniking 1. If you used ALL in Exercise 18, repeat the exercise using ANY. If you used ANY, repeat the exercise using ALL, and then run the new command. What question does the new command answer? 2. For each sales rep, ist the ID, fist name, and last name for the customer, alone with the sales rep first name, and sales rep last name. All reps should be included in the results Order the results by repiD. There are two sol commands for this query that lists the same results. Create and run each sal command. Module 5 Review Questions Exercises KimTax Pet Supplies 14. Ust the inwoice number and invoice date for each invoice that contains an inwoice line for a Wild Bird Food (25 p). 15. List the invoice number and invoice date for each invoice that eicher was created for James Gonzalez or that contains an invoice line for Wild Bird Food (25ib). 16. List the invoice number and invoice date for each invoice that was created for James Gonzalez and that contains an invoice line for Widd Bird Food (25ib). 17. List the invoice number and invoice date for each invoice that was created for James Gonzalez but that does not contain an invoice line for Widd Bird Food (2516). 18. List the item 10 , description, unit price, and category for each item that has a unit price greater than the unit price of every item in category CAT. Use either the ALL or ANY operator in vour query. (Hint: Make sure you select the correct operator.) 19. For each item, list the item 10 , description, units on hand, invoice number, and quantity ordered. All items should be induded in the results. For those items that are currently not on an invoice, the invoice number and quantity ordered should be left blank. Order the results bv item iD. Hiticar Thiniking 1. If you used ALL in Exercise 18, repeat the exercise using ANY. If you used ANY, repeat the exercise using ALL, and then run the new command. What question does the new command answer? 2. For each sales rep, ist the ID, fist name, and last name for the customer, alone with the sales rep first name, and sales rep last name. All reps should be included in the results Order the results by repiD. There are two sol commands for this query that lists the same results. Create and run each sal command
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started