Products Equal to Category Max

Problem

Return category, product, and price for products whose price equals the maximum price in their category.

Why This Matters

SQL interviews usually test whether you can turn a business question into the right rows, grouping level, join type, and edge-case behavior.

Schema

products(category TEXT, product TEXT, price INTEGER)

Examples

Constraints

• Return only the requested columns.
• Use deterministic ORDER BY when multiple rows are returned.
• Assume SQLite-compatible SQL unless the prompt states otherwise.