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