On January 28th at 9:00 UTC Academy will be unavailable for 10 minutes due to planned maintenance break.
Kickstart 2020 with new opportunities! - hours only!Up to 80% off on all courses and bundles.-Close
Ordering
Limiting the output
Eliminating duplicate results
Aggregation
Grouping
HAVING: filtering and ordering groups
23. Filter groups continued
Let's practice

Instruction

You're getting really good! Now, let's do one more exercise on filtering groups. Are you ready?

Exercise

Find all departments where the average salary in 2012 was greater than 3000. Show the department name together with the average salary. Name the column AvgDepartmentSalary.

Stuck? Here's a hint!

Type:

SELECT
Department,
AVG(Salary) AS AvgDepartmentSalary
FROM Employee
WHERE Year = 2012
GROUP BY Department
HAVING AVG(Salary) > 3000;