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.