Hi, I have a database and Product Table. Could you write a Sql Statement for; ho

Question

Hi, I have a database and Product Table.

Could you write a Sql Statement for;

how many order did give for the most expensive items ?

ProductID ProductName SupplierID CategoryID Unit Price 1 Chais 1 1 10 boxes x 20 bags 18 2 Chang 1 1 24 - 12 oz bottles 19 3 Aniseed Syrup 1 2 12 - 550 ml bottles 10 4 Chef Anton's Cajun Seasoning 2 2 48 - 6 oz jars 22 5 Chef Anton's Gumbo Mix 2 2 36 boxes 21.35 6 Grandma's Boysenberry Spread 3 2 12 - 8 oz jars 25 7 Uncle Bob's Organic Dried Pears 3 7 12 - 1 lb pkgs. 30 8 Northwoods Cranberry Sauce 3 2 12 - 12 oz jars 40 9 Mishi Kobe Niku 4 6 18 - 500 g pkgs. 97 10 Ikura 4 8 12 - 200 ml jars 31 11 Queso Cabrales 5 4 1 kg pkg. 21 12 Queso Manchego La Pastora 5 4 10 - 500 g pkgs.

Explanation / Answer

Select TOP (10) I.Price [Most expensive price]
from Items as I
order by I.Price DESC

Select TOP (10) I.Price [Least expensive price]
from Items as I
order by I.Price ASC

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.