[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 2 years ago
Question Tags: ,
2 Answers
0 Vote Up Vote Down
MockInterview Staff answered 2 years ago 
SELECT employee_number, name
   FROM employees emp
   WHERE salary > (
     SELECT AVG(salary)
       FROM employees
       WHERE department = emp.department);

0 Vote Up Vote Down
MockInterview Staff answered 2 years ago

Without correlated subquery: https://en.wikipedia.org/wiki/Correlated_subquery

Your Answer

8 + 5 =