Practice · easy · dataset: ecom
Price range by category
For each product category, report the cheapest price, the most expensive price, and the average price rounded to two decimals.
Return four columns: category, min_price, max_price, and avg_price. Sort by category
ascending.
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.