56

Most Popular Products

MediumJOINCOUNTORDER BY

Problem Description

Write a SQL query to find the top 3 most frequently ordered products.

Expected Columns

  • product_name
  • times_ordered

Example Output

| product_name | times_ordered | |--------------|---------------| | Laptop Pro | 3 | | Wireless Mouse | 3 | | Office Chair | 2 |

Hints

Unlocks after 2 more attempts
Submit your solution to unlock hints

Related Topics

JOINCOUNTORDER BYLIMIT
//#56 Most Popular Products
Medium

Loading schema...

Loading editor...

No results yet

Run a query to see results