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:
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 -...
-
An unstable particle is created in the upper atmosphere from a cosmic ray and travels straight down toward the surface of the earth with a speed of 0.99540c relative to the earth. A scientist at rest...
-
Every class has _________. a. Exactly one constructor b. At least one constructor c. At least two constructors d. A default constructor and a programmer-written constructor
-
Verify that both the pressure and the vorticity field satisfy the Laplace equation for Stokes flow. Verify that the velocity field satisfies the biharmonic equation \[\begin{equation*}abla^{4}...
-
1. Depreciation expense accounts would likely be found in the a. General fund b. Capital projects fund c. Debt service fund d. Enterprise fund 2. The government-wide statements of a state government...
-
Required information Problem 1-35A (Static) Recording events in a horizontal statements model LO 1-3, 1-4, 1-5, 1-6, 1-7, 1-8, 1-9, 1-10 [The following information applies to the questions displayed...
-
There is a paradigm that - "There is no point in training staff because they leave so it is an expensive and time consuming exercise!" Q: What is your opinion about the above paradigm?
-
4) The list of stocks appearing below is taken from the Dow Jones Industrial Average list of 30 stocks. Prices and dividend per share figures are as of 5/28/2016: SYMBOL AXP AAPL BA CAT CVX CSCO KO...
-
Review the Microsoft Windows 10 Hardening GUidelines https://www.microsoft.com/security/blog/2019/04/11/introducing-the-security-configuration-framework-a-prioritized-guide-to-hardening-windows-10/...
-
Outline the profile of Microsoft windows Security management. Put together an outline profile of Microsoft windows Security management and explanation of how to be presented. Include any materials...
-
Discuss the importance of signing in with a Microsoft Account or Local Account in Windows 10.?
-
An investor has $10,000 to invest in 5 different stocks. Information regarding the 5 stocks is shown in the table below: Stock Expected Return Beta Amount Invested ABCDE 9.00% 1.00 $1,701.00 10.00%...
-
What are the types of windows in Microsoft windows?
-
(1) Matilda consumes a composite good (c) and food (s). Her preferences are represented by the utility function u(c,s)= aln s + (1-a)Inc Suppose the price of the composite good and food ae Pc and Ps,...
-
On 1 July 2018, Parent Ltd acquired all the shares of Son Ltd, on a cum-div. basis, for $2,057,000. At this date, the equity of Son Ltd consisted of: $ 1,000,000 Share capital 500 000 shares...
-
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...
-
While the BohrSommerfeld condition sometimes gets the energy eigenvalues exactly correct, it can also be used for systems where the exact solution is not known. In this example, we will estimate the...
-
While we introduced the variational method and the power method both as a way to approximate the ground state of some system, they both can be used to approximate excited states as well, with...
-
It's useful to see how our quantum perturbation theory works in a case that we can solve exactly. Let's consider a two-state system in which the Hamiltonian is...
Study smarter with the SolutionInn App