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.