Filter Employees Table by Average Salary

sql
Copy
SELECT department_id, AVG(salary) AS average_salary
FROM employees
GROUP BY department_id
HAVING AVG(salary) > 100000;

This query groups the "employees" table by "department_id" and filters the results to return only those departments where the calculated average of the "salary" column exceeds 100,000.