Question

Write a query to show the price reduced by 10% for all products that are tables or entertainment centers with a standard price greater than or equal to $200. Show the discounted price under the heading "Sale Price". Order the results by increasing price.

Answer 1

Answer:

Below is the required code:

Explanation:

SELECT Product_Finish AS "Desk Finish",

avg(Standard_Price) AS "Average Price"

FROM Product_T

WHERE "Average Price">200

ORDER BY "Average Price" DESC;