Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Business Management Expert

This is the query: What is the heaviest weight and the average weight of a shipment? Name the columns with a literal of Heaviest_Weight and Average_Weight. Round the average weight answer to the nearest pound (i.e. no decimal places). (Hint: Embed the Avg function inside the Round function.) 

So Far I have answered it as this: Select MAX(weight) as 'Heaviest Weight', AVG(weight) as 'Average Weight'

From Shipment

Where Round(AVG('Average Weight')

Where am I going wrong. The error states that round function requires 2 to 3 arguments.

Business Management, Management Studies

  • Category:- Business Management
  • Reference No.:- M92807457
  • Price:- $10

Priced at Now at $10, Verified Solution

Have any Question?


Related Questions in Business Management

Interactive assignment instructionsenvironmental

Interactive Assignment Instructions Environmental Scanning Prior to entering this discussion, review section 4 of the Environmental-Trend Analysis in the Abraham's textbook. As you have learned in this week's readings, m ...

Let sigmaab give the transition diagram for a

Let Σ={a,b}. Give the transition diagram for a nondeterministic ?nite state machine that accepts the set of strings in {a,b}∗ that contain a substring of length four that begins and ends with the same symbol. For example ...

What is ethical dilemma that starbucks is cureently facing

What is ethical dilemma that starbucks is cureently facing ? How can I explain this ethical dilemma? What are the issues of the various stakeholders in this ethical dilemma? What is the right thing for the company to do ...

In c languageread a integer number which has 2 digits after

In C language: Read a integer number which has 2 digits after the decimal point. The number also has at least 6 digits the decimal point. Extract all digits at even positions from before the decimal point. Print them in ...

What are the corporate managerial influences of employing

What are the corporate managerial influences of employing and implementation of business ethics?

What is lean six sigma and what is used for in

What is Lean Six Sigma and what is used for in management?

Is project control different in an agile project what is

Is project control different in an Agile project? What is the role of a project manager in controlling an Agile project? What is the role of the project client, sponsor, or customer at controlling project changes?

Discuss how the concepts of diminishing marginal utility

Discuss how the concepts of diminishing marginal utility and utility maximization serve to underpin the concept of demand and quantity demanded. Include examples in your response.

What kinds of trainings that can be used to fix the problem

What kinds of trainings that can be used to fix the problem of staff do not understand their tasks?

Need some help with thisa contractors records during the

Need some help with this. A contractor's records during the least five weeks indicate the number of job requests: Week            1       2      3       4      5 Request        22   26    15    23     21 Predict the numb ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As