Question: Here is a Query Scenario, I need help with: The sales manager asks you to provide the average Pretax Sales amount throughout the years. Using

Here is a Query Scenario, I need help with:

The sales manager asks you to provide the average "Pretax Sales" amount throughout the years. Using the "Sales.SalesOrderHeader" table, what answer will you provide to the sales manager?

So far I have this, but i need to break it out by annual averages.

SELECT AVG (SubTotal) as AVG_Salespretax

FROM Sales.SalesOrderHeader

AVG_Salespretax

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Q:

The purpose of this assignment is to examine the use of aggregate functions, analyze queries that contain NULL values, and use CASE logic to resolve the data and arrive at a solution. For this...

Q:

1)How can cards, such as multicards, provide you with cleaner visuals? Select an answer: They remove irrelevant data and display the most relevant data. They provide summary data and an easier way of...

Q:

Subject : Sales management Answer below questions 1. How would you assess the profile of each salesperson? 2. How should Wiley allocate territories to the four TSMs? Why? Introduction It was Friday...

Q:

Introduction It was Friday afternoon at the regional ofce of Garrick Oil and Lubricants (GOAL) in Sudbury, Ontario. An email from the national VP. sales, had just arrived. This was the email that...

Q:

WEEK # 1 - EXERCISES Exercise 1 You oversee a young and growing business. You have identified the various factors (sources of revenue and expenses) that influence the business as shown in the table...

Q:

WEEK # 1 - EXERCISES Exercise 1 You oversee a young and growing business. You have identified the various factors (sources of revenue and expenses) that influence the business as shown in the table...

Q:

WEEK # 1 - EXERCISES Exercise 1 You oversee a young and growing business. You have identified the various factors (sources of revenue and expenses) that influence the business as shown in the table...

Q:

I have a attached a copy of the data used to answer the question Prepare a 2007 classified balance sheet and multistep income statement. Use the account balances from the unadjusted trial balance and...

Q:

SEE "DOCUMENT 1" FOR CRITERIA 2 "DOCUMENT 2" FOR CRITERIA 4 You are to write a 3 to 4 page paper following APA rules for the title page, citations and appropriate references within the body of the...

Q:

SEE "DOCUMENT 1" FOR CRITERIA 2 "DOCUMENT 2" FOR CRITERIA 4 You are to write a 3 to 4 page paper following APA rules for the title page, citations and appropriate references within the body of the...

Q:

Reconsider Prob. 6-129. Using EES (or other) software, investigate the effects of the heat engine source temperature, the environment temperature, and the cooled space temperature on the required...

Q:

Lorzo-Perez International has a subsidiary, the DelRay Sorter Company. The company believes the subsidiary on average will generate $1 million per year in annual net cash flows after necessary...

Q:

Why or why not? It is unethical It is illegal. The liquidation value is greater than the market value D The liquidation value is less than the market value The market value is less than the...

Q:

The current price of a commodity is $38. The interest rate is 7% per annum and the storage costs are 2% per annum, all rates are continuously compounded. If the 1.5-year forward price is $35.36, what...

Q:

7. Use marginal cost/marginal benefit analysis to determine if the following statement is true or false: The optimal amount of pollution abatement for some substances, say, dirty water from storm...

Q:

3. What is rent seeking and how does it differ from the kinds of profit maximization and profit seeking that we discussed in previous chapters? Provide an actual or hypothetical example of rent...

Q:

2. Government inspectors who check on the quality of services provided by retailers as well as government requirements for licensing in various professions are both attempts to resolve: LO4.6 a. The...