Provide a listing of all of the products that includes the d

Provide a listing of all of the products that includes the difference between its standard price and the
overall average standard price of all product

Product_t

ProductID, ProductDescription, ProductFinish, StandardPrice...

In SQL statement.

Solution

The following SQL query gives you the required functionality:

SELECT ProductID, StandardPrice - ( SELECT AVG( StandardPrice) from Product_t ) AS diff from Product_t;

Hope it helps, do give your response.