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 Individual rows before grouping occurs D The DISTINCT values of dept Show explanation
