Category Price Positioning

The pricing team at Whetcode Supply is deciding which categories to push in the next campaign and wants to know how premium each one currently reads. The measure they have settled on is the typical price of an item in that category — one figure per category, most premium first.

Note that this is about the catalogue, not about sales. A category can look premium and sell nothing, which is exactly the tension the campaign is meant to resolve.

products — the catalogue, one row per item on sale. price is what a single unit costs, in dollars.

The table already exists in the database — there is nothing to create or load.

Task: Write a query returning two columns, category and avg_price (the mean price of the items in that category, rounded to two decimal places), one row per category that has at least one product, highest mean first. Round the finished mean rather than each price on the way in. No two categories share a mean here.

Example output — shape only, on invented figures. The category labels are the real stored ones; a mean that does not land on a round number keeps its cents: