Show Reduced Price Query

Query to Show Price Reduction

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.

Question:

What is the SQL query to display the discounted price for tables and entertainment centers with a standard price of $200 or more?

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;