Write a query to show the price reduced by 10% for all products that are tables or entertainment centers with a standard price g
reater than or equal to $200. Show the discounted price under the heading "Sale Price". Order the results by increasing price.
1 answer:
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;
You might be interested in
I believe the answer is false
Answer:
C because it will work. I tried that a lot of time with documents.
Explanation:
It is called File Explorer
Answer:
What is your question?
Explanation:
Answer: What is this supposed to be about? Could you explain more? X.X