Question: Hey! I Need help with these problems for sql Question 1 What are our top selling items? Please show me the item name, price, and
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)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
