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.