Query Employees With Above Average Salary

sql
Copy
SELECT id, name, salary 
FROM employees 
WHERE salary > (SELECT AVG(salary) FROM employees);

This query uses a subquery to calculate the average salary of all records in the "employees" table and filters the result set to return only those employees whose salary exceeds that calculated value.