Practice · easy · dataset: ecom

Electronics catalog

The merchandising team is rebuilding the electronics landing page and needs the current catalog. Return every product in the electronics category with its id, name, and unit price.

Return three columns: product_id, name, and unit_price. Sort by unit price from highest to lowest, then by product_id ascending so the page order is stable.

Tables available

Table Columns
products product_id, name, category, unit_price

Every product has a category and a price, so no row needs special handling.

⌘/Ctrl + Enter to grade

Write a query, then grade it.

Hints

Try it first. Reveal a hint only when you are stuck.