SQL Subquery Exercises: Find out the names of all employees whose salary is greater than 50% of their department’s total salary bill
SQL SUBQUERY: Exercise-31 with Solution
Write a query which is looking for the names of all employees whose salary is greater than 50% of their department’s total salary bill.
Sample table: employees
SELECT e1.first_name, e1.last_name FROM employees e1 WHERE salary > ( SELECT (SUM(salary))*.5 FROM employees e2 WHERE e1.department_id=e2.department_id);
first_name last_name Kimberely Grant Jennifer Whalen Michael Hartstein Susan Mavris Hermann Baer Shelley Higgins
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
What is the difficulty level of this exercise?