Practice · easy · dataset: ecom
Top-priced products
Merchandising is picking products for a homepage carousel and wants to start from the most expensive stock. Return the five products with the highest unit price.
Return three columns: product_id, name, and unit_price. Sort from the highest unit price to
the lowest, and break ties by product_id ascending so the output is deterministic.
Tables available
| Table | Columns |
|---|---|
products |
product_id, name, category, unit_price |
Every product has a price, so there are no rows to special-case.
⌘/Ctrl + Enter to grade
Write a query, then grade it.
Hints
Try it first. Reveal a hint only when you are stuck.