Departments With Average Salary Over 80000
Medium
group-by
Google
LinkedIn
Meta
Find departments where the average employee salary exceeds 80,000. Return department and avg_salary (rounded to 2 decimal places), ordered by avg_salary descending.
Expected Output: Only departments with avg salary > 80000.
Tables
Hints (3 available)
SQL Editor
Output
Click "Run" to see results...