Group Prices by Category | Dataford Interview Questions

Guidewire PolicyCenter stores configurable product catalog entries with prices assigned to business categories. Write a PostgreSQL query that summarizes the catalog by category.

Requirements

Return each category and the sum of its non-null prices as total_price.
Sort the results from the highest total price to the lowest total price.

A null category should be treated as its own group. PostgreSQL's SUM behavior for null prices should be preserved.

Schema

policy_catalog

Column	Type	Description
catalog_idPK	INTEGER	Unique catalog entry identifier
product_name	VARCHAR(100)	Name of the PolicyCenter catalog product
category	VARCHAR(50)	Product category
price	NUMERIC(10,2)	Catalog price

Your question is Group Prices by Category. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem