An analyst needs departments whose total expenses exceed 100000 after grouping expense rows by department. Which clause filters the aggregate result?

Published
  1. HAVING SUM(expense) > 100000
  2. ORDER BY expense > 100000
  3. WHERE SUM(expense) > 100000
  4. LIMIT 100000

Comments — 0