Hi, I have a database and Product Table. Could you write a Sql Statement for; ho
ID: 3769569 • Letter: H
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
Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.