SQL query to retrieve name of employee with salary greater than department average.

• Calculate average salary of department using GROUP BY clause

• Join employee and department tables using department ID

• Fi...read more

SELECT e.emp_name, e.salary, e.dep_id FROM employees e WHERE salary > (SELECT avg(salary) FROM employees WHERE e.dep_id = dep_id ) ORDER BY dep_id;