Skip to main content
All Problems
medium0% acceptance

Most Expensive Product Per Category

For each category, find the product with the highest price. Return the category name, product name, and price. Use a correlated subquery to identify the max-priced product.

Schema

🔑idINT
nameTEXT
descriptionTEXTNULL
postgresql

Run your query to see results

Press Ctrl + Enter to execute