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.