Min and Max Prices — Solution & ExplanationProblems / Min and Max Prices / EditorialApproach

GROUP BY category to partition products.

Apply MIN(price) and MAX(price) in the same query to get both extremes per category.

ORDER BY category for deterministic output.

Key ConceptYou can compute multiple aggregates in a single pass over the data. Each aggregate function operates independently on the same groups.Hints

You can use multiple aggregate functions in one SELECT / agg() call.

MIN() and MAX() work on numeric, string, and date types.

Solve Min and Max Prices yourself →