MAX and MIN
Intermediate
The catalogue page shows, for every product category, the price range of its items.
Write a query returning each category of products with its highest price as max_price and its lowest price as min_price.
Constraints
- Columns, in order:
category,max_price,min_price - One row per category
Hints
Hint 1
MAX and MIN are aggregates, so they need GROUP BY category.
Hint 2
Both can appear in the same SELECT.
Keywords
db
SQL
Run your code to see results
No results yet
Run your code to check it against the examples, or submit to run every test.