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) None of the above

Question

Quizplus · Accepted Answer

The SQL statement is selecting the average of the standard_price column from the product_v table, therefore it will produce the average standard_price of all products in product_v.

What Result Will the Following SQL Statement Produce