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.