FREE Trial
Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Problem 15, Need help please. Use a query to compute the total of all purchases, the number of purchases, and the average purchase amount made

Problem 15, Need help please. Use a query to compute the total of all purchases, the number of purchases, and the average purchase amount made by each customer. Your output values must match those shown in Figure P7.15. Sort the results by customer code.

image text in transcribed

CUS_CODE CUS_BALANCE Total Purchases Number of Purchases Average Purchase Amount 10011 0.00 444.00 6 74.00 10012 345.86 153.85 3 51.28 10014 0.00 422.77 6 70.46 10015 0.00 34.97 2 17.49 10018 216.55 70.44 1 70.44

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Professional Microsoft SQL Server 2014 Administration

Professional Microsoft SQL Server 2014 Administration

Authors: Adam Jorgensen, Bradley Ball

1st Edition

111885926X, 9781118859261

More Books

Students also viewed these Databases questions

Question

★★★★★
What federal statutes have been enacted to protect privacy rights?

Answered: 1 week ago

Question

★★★★★
Consider two string-suspended balls, both with a mass of 0.15 kg. (Similar to the arrangement in Fig. 6.15, but with only two balls.) One ball is pulled back in line with the other so it has a...

Answered: 1 week ago

Question

★★★★★
Planning: Analyzing the Situation, Selecting Media; Media Skills: Email [LO-4] Your crisis communications firm has been hired to project the right the image of a pharmaceutical company. In recent...

Answered: 1 week ago

Question

★★★★★
Leverage Partnerships balance sheet as of July 31, 2014, follows. The partnersGauri, Tailor, and Pavelshare income and losses in the ratio of 5:3:2. Because of a mutual disagreement, Gauri, Tailor,...

Answered: 1 week ago

Question

★★★★★
An indoor 50 ft3 Propane tank is needed for casting processes. The tank is confined in a 1000 ft3 rectangular room with 15 ft. height. The fire engineer calculated the room strength to withstand the...

Answered: 1 week ago

Question

★★★★★
he table below provides data on a company under two alternative capital structures and 3 possible states of the economy - the three state can roughly be described as bad, better, best. What do the...

Answered: 1 week ago

Question

★★★★★
Deena Precision Tools (DPT) makes cutting tools for metalworking operations. It makes two types of tools: RC6, a regular cutting tool, and HP4, a high precision cutting tool. RC6 is manufactured on a...

Answered: 1 week ago

Question

★★★★★
1)The estate of Aisha Gopaul will be receiving a $25,000 death benefit from a Saskatchewan based organisation. Calculate the tax to be withheld from this amount 2)Sean works in Ontario and is...

Answered: 1 week ago

Question

★★★★★
The adjusted trial balance of ZZZ Corp.on December 31, 2014 includes the following account balances: Dividends Payable P 40,000 Ordinary share Capital (P5 par, 5,000 shares authorized) 750,000...

Answered: 1 week ago

Question

★★★★★
Record journal entries for each of the following transactions. 1. On Aug. 1, Martin Johnson invests $425,000 to open his new appliance repair business. 2.On Aug. 3, the company pays $150,000 for land...

Answered: 1 week ago

Question

★★★★★
Dearborn and Dyehardt (D&D) has just put Forzosein on the market, a new compound that may be able to save the lives of people who suffer from cancer. D&D charges hundreds of times what it cost the...

Answered: 1 week ago

Previous Question Next Question