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 Individual rows before grouping occurs B Rows returned by a subquery C Aggregated group-level results after GROUP BY is applied D The DISTINCT values of dept Show explanation
