Heaviest weight and the average weight of a shipment

Assignment Help Business Management
Reference no: EM131969804

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.

Reference no: EM131969804

Questions Cloud

Describe np practice in your state of maryland : Describe NP practice in your state of Maryland. Tell the class what Maryland state laws are related to nurse practitioner prescribing.
Calculate the weighted average cost of capital for the firm : C Ltd. has the following capital structure: Form of capital Weight After-tax cost. Calculate the weighted average cost of capital for the firm
Analyze the power the agency has in enforcing : Analyze the power the agency has in enforcing the regulations they are asked to uphold.Discuss two to three challenges to enforce the agency's regulations.
Identify the benefits and challenges of strategic planning : Using specific examples and support from your Learning Resources, identify the benefits and challenges of strategic planning in health care.
Heaviest weight and the average weight of a shipment : This is the query: What is the heaviest weight and the average weight of a shipment? Name the columns with a literal of Heaviest
Describe the requirements for expert witness testimony : Review Rule 702 of the Federal Rules of Evidence. What qualifies a witness as an expert? Describe the requirements for expert witness testimony
What are the key elements of each strategic plan : What are the key elements of each Strategic Plan? Compare the goals and strategies identified in each one. Which plan is likely to be more successful and why?
Elementary school student learn multiplication : Use the Random method to produce two positive one-digit integers. The program should then prompt the user with a question using random numbers, such as
Research the service process for the selected company : Select two companies of interest, one manufacturing company (e.g., a shoe company) and one service company (e.g., a technical support company).

Reviews

Write a Review

Business Management Questions & Answers

  What will happen to existing supply avenues

There is much discussion in the press about several states moving to legalizing marijuana, either for only medical purposes, or more extremely

  Describe the stages of group development

Describe the stages of group development. What one positive and one negative elements do you feel have the greatest impact on group development?

  Does it allow a balanced appraisal of all three parameters

Does it allow a balanced appraisal of all three parameters? Why or why not? What would the two sides of the argument be?

  Form of economic policy

Contractionary monetary policy is a form of economic policy used to fight inflation which involves decreasing the money supply in order to increase the cost of borrowing which in turn decreases GDP and dampens.

  Which big five dimensions does teach for america screening

Which Big Five dimensions does Teach for America's screening system seem to prioritize? Are there other dimensions that would seem relevant to the performance or commitment of teachers?

  Competing in foreign markets

Because similarities in buyer tastes and preferences creates challenges in standardizing products and services.

  Identify a crisis scenario

Identify a crisis scenario. Create a role-play scenario of how a leader can use emotional intelligence to handle a crisis or conflict situation. You may research a crisis event, such as a product recall, oil spill, or natural disaster and create a..

  What are the incremental earnings associated with the advert

Kokomochi is considering the launch of an advertising campaign for its latest dessert product, the Mini Mochi Munch. Kokomochi plans to spend $5 million on TV, radio, and print advertising this year for the campaign. The ads are expected to boost sal..

  Importance of young worker training

As a group, discuss the importance of young worker training, and list how and why it differs from the mature worker's needs? When putting together a training plan for new or young workers, what topics should be included in the training?

  Startup business structure

Making craft items and selling them on the internet. Review this condition and analyze that affect the decision on business structure.

  Forecast using trend-adjusted

What is this year's forecast using trend-adjusted (double) smoothing with alpha = .2 and beta = .1, if the forecast for last year was 56 the forecast

  Explain the difference between active and latent error

Explain the difference between active and latent error. Give an example of each. Which do you think is the most common in health care?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd