Departments With Average Salary Above Threshold
Medium
joins
Google
Meta
Netflix
Join employees (which has salaries) with departments, compute the average salary per department, and return only departments where the average salary exceeds 70000.
Expected Output
| dept_name | avg_salary |
|---|---|
| Engineering | 90000.0 |
| Finance | 80000.0 |
Tables
Hints (3 available)
SQL Editor
Output
Click "Run" to see results...