HAVING with MAX

Question

HAVING with MAX

Accepted Answer

MAX(price) per category: Books = 18, Toys = 45, Food = 5. HAVING MAX(price) < 40 keeps only categories where even the most expensive item is below 40. Toys has a max of 45, so it is excluded. Both Books (max 18) and Food (max 5) pass the filter.