What results will be produced by the following SQL query?
SELECT SUM(Standard_Price) as Total_Price
From Product_V
Where Product_Type = 'WOOD';

A) The total price of all products that are of type wood
B) The total price of all products
C) The Standard_Price of the first wood product in the table
D) The Standard_Price of any wood product in the table

Question

What results will be produced by the following SQL query? 
SELECT SUM(Standard_Price) as Total_Price
From Product_V
Where Product_Type = 'WOOD';

A) The total price of all products that are of type wood
B) The total price of all products
C) The Standard_Price of the first wood product in the table
D) The Standard_Price of any wood product in the table

Quizplus · Accepted Answer

The query calculates the sum of the Standard_Price for all products in the Product_V table where the Product_Type is 'WOOD'.

What Results Will Be Produced by the Following SQL Query