Seagul

Lesson 5 - 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.

Hints

Hint 1

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

Not completed

Loading dataset...

Latest result

No result set available.