Which of the following calculates the average of the values in the OnHand field? a. SELECT AVERAGE(OnHand)

Question:

Which of the following calculates the average of the values in the OnHand field?
a. SELECT AVERAGE(OnHand) AS Available FROM dbo.Inventory
b. SELECT OnHand.AVG AS Available FROM dbo.Inventory
c. SELECT AVG(OnHand) AS Available FROM dbo.Inventory
d. SELECT AVG.OnHand AS Available FROM dbo.Inventory

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Question Posted: