Which query will use the given columns and column aliases from the PRODUCT table to determine the total value of inventory held on hand and display the results in a column labeled TOTVALUE?
A) SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH*P_PRICE AS TOTVALUE
FROM PRODUCT;
B) SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH=P_PRICE AS TOTVALUE
FROM PRODUCT;
C) SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH/P_PRICE AS TOTVALUE
FROM PRODUCT;
D) SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH-P_PRICE AS TOTVALUE
FROM PRODUCT;

Question

Quizplus · Accepted Answer

The query should include the columns P_QOH and P_PRICE, and their product (P_QOH*P_PRICE) should be calculated and displayed as a new column with the alias TOTVALUE. This will give the total value of inventory held on hand. Option A fulfills this requirement. Options B, C, and D do not provide the correct calculation.

Which Query Will Use the Given Columns and Column Aliases