SQL Data Analyst — Hard An analyst writes: SELECT dept, AVG(salary) FROM employees GROUP BY dept HAVING AVG(salary) > 70000. What does HAVING filter on here? A Rows returned by a subquery B Aggregated group-level results after GROUP BY is applied C The DISTINCT values of dept D Individual rows before grouping occurs Show explanation
