5a) Produce a query that pulls each sale for what customer done by what clerks, the...
Fantastic news! We've Found the answer you've been seeking!
Question:
![5a) Produce a query that pulls each sale for what customer done by what clerks, the date and total amount:](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2023/09/64fabf2fd7ac8_1694154542542.jpg)
![Applications | Rapidld X N Exercise 5 - Pet Shop X C File |](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2023/09/64fabf3e41385_1694154557264.jpg)
Transcribed Image Text:
5a) Produce a query that pulls each sale for what customer done by what clerks, the date and total amount: • Clerk with McNally would be your name, not mine • Total is already figured out, so you don't have to do a sum here • Remember to use the matching Aliases • 3 tables, Sale, Customer and Employee Export the output and save the SQL, load both to Canvas as [initials]5a.cvs and [initials]5a.sql 5b) Create a query to retrieve Customers that bought what Merchandise: Customer Brand Bear Bear Bear Bear Fox Fox Skunk Skunk Skunk Skunk Skunk FreshFeed Petinc Four tables used here; Customer, Sale, Saleltems and Merchandise • Remember to use the matching Aliases FreshFeed Petinc Kong Item Cat Food Pet bed Dog Food Pet bed Dog Pull Rope Dog Food FreshFeed FreshFeed AguaPets AguaPets Tank filter Fish Food Tank 30 gallons Customer Clerk AguaPets Tank gravel FreshFeed Cat Food Wood Skunk Bear Fox Skunk Bear Purchase Total Date Robin 11/1/2018 161.47 Robin 11/1/2018 158.96 McNally 11/1/2018 92.75 McNally 11/2/2018 252.97 McNally 11/2/2018 25 Robin 11/3/2018 114.73 Applications | Rapidld X N Exercise 5 - Pet Shop X ← → CⒸ File | C:/Users/phanl/Downloads/Exercise5_Pet%20Store%20Data.pdf III Exercise 5 Create Pet Store Data 83°F Mostly cloudy 1 2 = 3 Exercise 5 Create Pet X * Dashboard E ▬▬▬ 3 / 3 | ● - ● 90% ● X Student Center 5c) Create a query to retrieve Customers that bought what Animals: Four tables here as well; Customer, Sale, Saleltems and Animals Use the matching Aliases + 8 Export the output and save the SQL, load both to Canvas as [initials]5c.cvs and [initials]5c.sql Q Search EXERCISE 5 CREATE PET STORE DATA 5d) Last one, figure out the total sales for each Clerk. X C My Orders | Chegg.co X Item Siamese Cat Bear Customer Animal Bear Sam Cooper Dachshund Canine Percie Australian Shepherd Canine Gold Fish Fox Gerbil Skunk Wood Bella Buddy Only two tables needed here: Employees and Sales. Use the matching Aliases You will need a Sum() and Group by Amount Sold Robin 435.16 McNally 370.72 Clerk Export the output and save the SQL, load both to Canvas as [initials]5d.cvs and [initials]5d.sql Make sure you Upload one SQL file and one output CVS file for 5a-5d each (8 files) to Canvas. 4 A ENG 4 5:24 PM 4/16/2023 X ⠀ I 5a) Produce a query that pulls each sale for what customer done by what clerks, the date and total amount: • Clerk with McNally would be your name, not mine • Total is already figured out, so you don't have to do a sum here • Remember to use the matching Aliases • 3 tables, Sale, Customer and Employee Export the output and save the SQL, load both to Canvas as [initials]5a.cvs and [initials]5a.sql 5b) Create a query to retrieve Customers that bought what Merchandise: Customer Brand Bear Bear Bear Bear Fox Fox Skunk Skunk Skunk Skunk Skunk FreshFeed Petinc Four tables used here; Customer, Sale, Saleltems and Merchandise • Remember to use the matching Aliases FreshFeed Petinc Kong Item Cat Food Pet bed Dog Food Pet bed Dog Pull Rope Dog Food FreshFeed FreshFeed AguaPets AguaPets Tank filter Fish Food Tank 30 gallons Customer Clerk AguaPets Tank gravel FreshFeed Cat Food Wood Skunk Bear Fox Skunk Bear Purchase Total Date Robin 11/1/2018 161.47 Robin 11/1/2018 158.96 McNally 11/1/2018 92.75 McNally 11/2/2018 252.97 McNally 11/2/2018 25 Robin 11/3/2018 114.73 Applications | Rapidld X N Exercise 5 - Pet Shop X ← → CⒸ File | C:/Users/phanl/Downloads/Exercise5_Pet%20Store%20Data.pdf III Exercise 5 Create Pet Store Data 83°F Mostly cloudy 1 2 = 3 Exercise 5 Create Pet X * Dashboard E ▬▬▬ 3 / 3 | ● - ● 90% ● X Student Center 5c) Create a query to retrieve Customers that bought what Animals: Four tables here as well; Customer, Sale, Saleltems and Animals Use the matching Aliases + 8 Export the output and save the SQL, load both to Canvas as [initials]5c.cvs and [initials]5c.sql Q Search EXERCISE 5 CREATE PET STORE DATA 5d) Last one, figure out the total sales for each Clerk. X C My Orders | Chegg.co X Item Siamese Cat Bear Customer Animal Bear Sam Cooper Dachshund Canine Percie Australian Shepherd Canine Gold Fish Fox Gerbil Skunk Wood Bella Buddy Only two tables needed here: Employees and Sales. Use the matching Aliases You will need a Sum() and Group by Amount Sold Robin 435.16 McNally 370.72 Clerk Export the output and save the SQL, load both to Canvas as [initials]5d.cvs and [initials]5d.sql Make sure you Upload one SQL file and one output CVS file for 5a-5d each (8 files) to Canvas. 4 A ENG 4 5:24 PM 4/16/2023 X ⠀ I
Expert Answer:
Answer rating: 100% (QA)
It seems you need assistance with creating SQL queries for certain tasks related to a pet stores sales data Unfortunately Im unable to provide exact S... View the full answer
Related Book For
Auditing A Practical Approach with Data Analytics
ISBN: 978-1119401742
1st edition
Authors: Raymond N. Johnson, Laura Davis Wiley, Robyn Moroney, Fiona Campbell, Jane Hamilton
Posted Date:
Students also viewed these databases questions
-
Identify one star and one question mark brand from the current Hershey's brand portfolio ( review BCC matrix and what each means ) . Justify your choice
-
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...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
Use the ideas of Richardson's extrapolation and Romberg's method to evaluate the first derivative of f = ex at x = 0. To construct the first column of the Romberg's table, use the formula (exth -...
-
A firm uses cloth and labor to produce shirts in a factory that it bought for $10 million. Which of its factor inputs are measured as flows and which as stocks? How would your answer change if the...
-
A cooling system is to be designed for a food storage warehouse for keeping perishable foods cool prior to transportation to grocery stores. The warehouse has an effective surface area of 1860 m 2...
-
Where are the young more likely to live? Figure 11.10 (page 231) is a stemplot of the percentage of residents aged under 18 in each of the 50 states. The stems are whole percents and the leaves are...
-
On January 2, 2012, Banno Corporation issued $1,500,000 of 10% bonds at 97 due December 31, 2021. Interest on the bonds is payable annually each December 31. The discount on the bonds is also being...
-
QUESTION 1 12 points Save Answer For the following financial statement items, calculate trend percentages using 2016 as the base year. State whether the situation as revealed by the trends appears to...
-
Wayland Custom Woodworking is a firm that manufactures custom cabinets and woodwork for business and residential customers. Students will have the opportunity to establish payroll records and to...
-
Discuss the value of the brokerage community. What do brokers provide for market participants, owners, developers, users, tenants, both collectively and individually? How are these benefits delivered...
-
1. What gives stainless steels their good corrosion resistant properties? 2. Which stainless steel is the lowest cost and why? 3. What are some characteristics of Nickel Alloys? 4. What are the 2...
-
Problem 4. Determine the motion of a two-dimensional linear oscillator of potential energy V = kr
-
5 Informatics solutions in the "complex and catastrophic" end of the population-risk spectrum must support which type of services/functions? 1 point Intensive case management Wellness program
-
What are the characteristics of products that Otis Trains produces? What are order qualifiers and winners? Explain at least three advantages and three drawbacks of offshoring to JLPTC. What risks are...
-
Find the angle and length of the resulting vector for the given d and e vectors by the analytical method. After that, find the parameters of the resulting vector for the three vectors. In the answer,...
-
Percent of capital structure: 10 points Debt Preferred stock Common equity (retained earnings) 10% 5 85 eBook Additional information: BO Hint Bond coupon rate Bond yield to maturity Dividend,...
-
Consider the discrete group G of order 8 that has the following Cayley diagram e If we have the sequence of operations: fcagec, which of the options represents the reduction of the sequence to a...
-
Do only publicly traded companies have good corporate governance? Explain.
-
a. Information gathering: Prepare a list of questions that the auditors would ask MSI managers regarding how the impairment loss was determined. b. Analysis and evaluation: Comment on the level of...
-
When performing ADA as a risk assessment procedure, a notable item: a. Is indicative of a risk of material misstatement not previously identified by the auditor. b. Is indicative of a higher risk of...
-
23. How are fiduciary funds reported on government-wide financial statements?
-
24. What are some of the major differences that exist between private colleges and universities and pub lic colleges and universities that affect financial reporting?
-
2. A city government has a six-year capital lease for property being used within the General Fund. Minimum lease payments total $70,000 starting next year but have a current present value of $49,000....
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App