Your question is Group Prices by Category. Start with the requirements and the one table on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
Guidewire PolicyCenter stores configurable product catalog entries with prices assigned to business categories. Write a PostgreSQL query that summarizes the catalog by category.
total_price.A null category should be treated as its own group. PostgreSQL's SUM behavior for null prices should be preserved.
| 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 |