What result will the following SQL statement produce? Select Avg(standard_price) as average from Product_V;
A) The average of all products in Product_V
B) The average Standard_Price of all products in Product_V
C) The average price of all products
D) The mode of all prices

Question

Quizplus · Accepted Answer

The SQL statement will produce the average of the Standard_Price column of all products in the Product_V table, as specified by the AVG function used with the alias "average".

What Result Will the Following SQL Statement Produce? Select Avg(standard_price)