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