to complete the Use SQL and the Kim Tay Pet Supplies database following exercises. If directed...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
to complete the Use SQL and the Kim Tay Pet Supplies database following exercises. If directed to do so by your instructor, use the information provided with the Module 3 Exercises to print your output or save it to a document. 1. 2. For each invoice placed on November 15, 2021, list the invoice number along with the ID, first name, and last name of the customer for which the invoice was created. 3. For each invoice, list the invoice number, invoice date, item ID, quantity ordered, and quoted price for each invoice line that makes up the invoice. For each invoice, list the invoice number and invoice date along with the ID, first name, and last name of the customer for which the invoice was created. 4. Use the IN operator to find the ID, first name, and last name of each customer for which as invoice was created on November 15, 2021. 5. 6. 8. 9. 7. For each invoice, list the invoice number, invoice date, item ID, description, and category for each item that makes up the invoice. 10. 11. Repeat Exercise 4, but this time use the EXISTS operator in your answer. Find the ID, first name, and last name of each customer for which an invoice was not created on November 15, 2021. Repeat Exercise 7, but this time order the rows by category and then by invoice number. Use a subquery to find the sales rep ID, first name, and last name of each sales rep who represents at least one customer with a credit limit of $500. List each sales rep only once in the results. Repeat Exercise 9, but this time do not use a subquery. Find the ID, first name, and last name of each customer that currently has an invoice on file for Wild Bird Food (25 lb). 12. List the item ID, description, and category for each pair of items that are in the same category. (For example, one such pair would be item FS42 and item PF19, because the category for both items is FSH.) 13. List the invoice number and invoice date for each invoice created for the customer James Gonzalez. 14. List the invoice number and invoice date for each invoice that contains an invoice line for a Wild Bird Food (25 lb). 15. List the invoice number and invoice date for each invoice that either was created for James Gonzalez or that contains an invoice line for Wild Bird Food (25 lb). 16. List the invoice number and invoice date for each invoice that was created for James Gonzalez and that contains an invoice line for Wild Bird Food (25 lb). 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 Wild Bird Food (25 lb). 18. List the item ID, 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 your query. (Hint: Make sure you select the correct operator.) 19. For each item, list the item ID, description, units on hand, invoice number, and quantity ordered. All items should be included 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 by item ID. to complete the Use SQL and the Kim Tay Pet Supplies database following exercises. If directed to do so by your instructor, use the information provided with the Module 3 Exercises to print your output or save it to a document. 1. 2. For each invoice placed on November 15, 2021, list the invoice number along with the ID, first name, and last name of the customer for which the invoice was created. 3. For each invoice, list the invoice number, invoice date, item ID, quantity ordered, and quoted price for each invoice line that makes up the invoice. For each invoice, list the invoice number and invoice date along with the ID, first name, and last name of the customer for which the invoice was created. 4. Use the IN operator to find the ID, first name, and last name of each customer for which as invoice was created on November 15, 2021. 5. 6. 8. 9. 7. For each invoice, list the invoice number, invoice date, item ID, description, and category for each item that makes up the invoice. 10. 11. Repeat Exercise 4, but this time use the EXISTS operator in your answer. Find the ID, first name, and last name of each customer for which an invoice was not created on November 15, 2021. Repeat Exercise 7, but this time order the rows by category and then by invoice number. Use a subquery to find the sales rep ID, first name, and last name of each sales rep who represents at least one customer with a credit limit of $500. List each sales rep only once in the results. Repeat Exercise 9, but this time do not use a subquery. Find the ID, first name, and last name of each customer that currently has an invoice on file for Wild Bird Food (25 lb). 12. List the item ID, description, and category for each pair of items that are in the same category. (For example, one such pair would be item FS42 and item PF19, because the category for both items is FSH.) 13. List the invoice number and invoice date for each invoice created for the customer James Gonzalez. 14. List the invoice number and invoice date for each invoice that contains an invoice line for a Wild Bird Food (25 lb). 15. List the invoice number and invoice date for each invoice that either was created for James Gonzalez or that contains an invoice line for Wild Bird Food (25 lb). 16. List the invoice number and invoice date for each invoice that was created for James Gonzalez and that contains an invoice line for Wild Bird Food (25 lb). 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 Wild Bird Food (25 lb). 18. List the item ID, 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 your query. (Hint: Make sure you select the correct operator.) 19. For each item, list the item ID, description, units on hand, invoice number, and quantity ordered. All items should be included 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 by item ID.
Expert Answer:
Related Book For
Accounting Information Systems
ISBN: 978-0133428537
13th edition
Authors: Marshall B. Romney, Paul J. Steinbart
Posted Date:
Students also viewed these databases questions
-
Greer Manufacturing purchases property that includes land, buildings and equipment for $4.5 million. The company pays $173,000 in legal fees, $218,000 in commissions, and $106,000 in appraisal fees....
-
The reference base period for Dexter's CPI is 2004. What is the CPI in 2005? 169 129 102 59
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Ancient Indians did not believe in war and violence when it came it an expansion of political territory but relied on peaceful negotiation and strategy. Please explain your views on this quote with...
-
What is the hydribization of each carbon atom in acetonitrile (Problem 1.25)?
-
In Exercises 1, which of the given quadratic forms in three variables are equivalent? 81 (x) = x + 2x1x3 82(x) = 2xf + 2x1+11 + 2x1x2 + 2xM3 + 2x2x3 83(x) = 2x1x2 + 2x1x3 + 2x2x3 84 (x) = 4x1 + 3x1 +...
-
Two protons are fired toward each other on closely spaced paths, one moving in the \(+z\) direction and one in the \(-z\) direction. As they pass close to each other, is the magnetic force between...
-
Pueblo Enterprises is considering investing in either of two mutually exclusive projects, X and Y. Project X requires an initial investment of $30,000; project Y requires $40,000. Each projects cash...
-
123456 7 8 Define plant location. Define product layout and process layout. What are the methods of production? Define work study. What do you mean by method study and time study? Explain inventory...
-
return and covariance matrix are given as follows. L2 Three securities are available for investment, and their expected rates of 3 = 0.12 0.02 0.02 2 01 012 2 021 02 013 023 2 031 032 03 = 0.04...
-
Bill, age 27, earns a salary of $100,000 in 2020 when the consumer price index was 258. Bill's father earned a salary of 30,000 when the consumer price index was 85.5. As for 2020, who earned a...
-
The Federal Trade Commission targeted deceptive diet advertisements by weight-loss marketers. Your Task. When indirectness or tact is required, use passive-voice verbs. Revise the above sentence so...
-
Jason Berry submitted his proposalhoweverhe forgot to enclose the budget. For the above sentence, insert any necessary semicolons, commas, or colons. Count the number of marks you add. Write that...
-
Workers were asked to wear badges with tiny sensors to monitor their communication and activity patterns at Bank of America. Your Task. Business writing is more forceful when it uses active-voice...
-
Which sentence is more emphatic? Why? a. The new restaurant will attract foot traffic and also serve unique burgers. b. The new restaurant will attract foot traffic and, most important, will serve...
-
Bottled water consumption rose 2.2 percent in volume last year. Your Task. For each of the above numbered sentences, select the letter that identifies its type: a. Simple sentence b. Compound...
-
Youll write a program named imgGen that creates asimple Portable GrayMap (PGM) image file. Your program will create the file data in memory (in a2-d array) and then write it to a disk file Youll then...
-
Describe basic managerial approaches to implementing controls and how these are implemented.
-
As manager of a local pizza parlor, you want to develop a balanced scorecard so you can more effectively monitor the restaurants performance. Required a. Propose at least two goals for each...
-
Answer the following questions about the audit of Springers Lumber & Supply a. What deficiencies existed in the internal environment at Springers? b.Do you agree with the decision to settle with the...
-
Joe, the owner of the ice-cream shop, purchases ice cream from two vendors. Over the years, he has developed good relationships with both vendors so that they allow Joe to pay them biweekly for all...
-
Figure P4.2 shows the velocity of a block of wood as a function of time. The block is sliding over a horizontal surface. Describe the physical processes that led to this graph. Data from Figure P4.2...
-
Consider the two velocity-versus-time graphs shown in Figure P4.4. Are the motions represented by these curves best described as similar or as different? Is the effect of friction on the motion...
-
The velocity-versus-time graph in Figure P4.3 shows the motion of two different objects sliding across a horizontal surface. Could the change in the \(x\) component of velocity with time be...
Study smarter with the SolutionInn App