Practice · easy · dataset: ecom
Mid-range product prices
Category managers want to review products priced between 200 and 300, inclusive of both endpoints.
Return product_id, name, and unit_price for every product in that band.
Sort by unit_price ascending, then by product_id ascending so the review list is
deterministic.
Tables available
| Table | Columns |
|---|---|
products |
product_id, name, category, unit_price |
⌘/Ctrl + Enter to grade
Write a query, then grade it.
Hints
Try it first. Reveal a hint only when you are stuck.