[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 4 months ago

[Content Sponsor #1] Start learning through a free trial on Datacamp!
[Content Sponsor #2] $750 discount on any springboard courses including Data Science Career Track which comes with a Job Guarantee!

Question Tags: ,
2 Answers
0 Vote Up Vote Down
MockInterview Staff answered 4 months ago 
SELECT employee_number, name
   FROM employees emp
   WHERE salary > (
     SELECT AVG(salary)
       FROM employees
       WHERE department = emp.department);

[Content Sponsor #1] Start learning through a free trial on Datacamp!
[Content Sponsor #2] $750 discount on any springboard courses including Data Science Career Track which comes with a Job Guarantee!

0 Vote Up Vote Down
MockInterview Staff answered 4 months ago

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


[Content Sponsor #1] Start learning through a free trial on Datacamp!
[Content Sponsor #2] $750 discount on any springboard courses including Data Science Career Track which comes with a Job Guarantee!

Your Answer

20 + 6 =

Data Science Career Bootcamp