This website uses cookies to ensure you get the best experience.
Learn more.
An analyst needs departments whose total expenses exceed 100000 after grouping expense rows by department. Which clause filters the aggregate result?
Published
- HAVING SUM(expense) > 100000
- ORDER BY expense > 100000
- WHERE SUM(expense) > 100000
- LIMIT 100000
Comments — 0
Sign in to comment