Seagull

Lesson 5 - 7. Most purchased menu item

Dataset statusAdvanced SQL exercisesvv1

Exercise content

Using the sales and menu tables, find the menu item purchased the most times.

Show the columns product_name and purchase_count.

Order by purchase_count DESC, product_name ASC and return only one row.

Hint 1
Join sales and menu to get product_name. Then group by product and use COUNT(*).

Not completed

Loading dataset...

No result set available.