Departments with high average salary

Using the instructor table, find the departments whose average instructor salary is greater than 100000. Return dept_name and the average salary as avg_salary, including only departments above the threshold.

Order the result by avg_salary (highest first), then by dept_name.

---

Database schema

−+Fit
primary keyforeign keyarrow points to the referenced columndrag to pan