[SQL] use correlated subquery to find all employees whose salary is above average for their department

Data Science Interview Questions › Category: Data Science › [SQL] use correlated subquery to find all employees whose salary is above average for their department

0 Vote Up Vote Down

MockInterview Staff asked 7 months ago

[Content Sponsor] $750 discount on any springboard courses including Data Science Career Track which comes with a Job Guarantee!

Question Tags: Data Science, SQL

2 Answers

0 Vote Up Vote Down

MockInterview Staff answered 7 months ago

SELECT employee_number, name
   FROM employees emp
   WHERE salary > (
     SELECT AVG(salary)
       FROM employees
       WHERE department = emp.department);