Question 1 \"What are our top selling items? Please show me the item name, price

Question

Question 1 "What are our top selling items? Please show me the item name, price, and number sold, but limit it to only just the top ten (10) and list them in order of number sold and menuid (Hint Google how to limit results returned.) Your results should match this exactly l item name price I qty l I menuiten35 I 1.83 l 3743 I menuitem2 I 1.63 l 3742 I menuitem45 1.98 l 3739 I nenuitem41 l 6.66 l 3719 l I menuitem26 l 3.88 1 3718 l menuiteme l 8.35 l 3717 l I manuitem40 3.34 I 3717 l nanuitem13 l 3.30 l 3713 l l menuiten? 9.96 i 3675 l 36711 2.84 l menuitem3 10 rows in set (0.18 sec)

Explanation / Answer

1)
Select item_name, price, qty
From tablename
Order by qty desc
Limit 10;

2)
Select item_name, price, qty, tsales
From tablename
Order by qty desc
Limit 10;

3)
Select item_name, price, qty
From tablename
Order by tsales desc
Limit 10;

4)
select day, sum(qty)
from tablename
where item_name="menuitem7"
groupby day;

5)
select year, sum(qty), sum(tsales)
from tablename
where item_name="menuitem7" and day="Sunday"
groupby year;

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

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