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;