[Exp 2]
High-Earner Department Analytics (Correlated Subqueries)
UNIT-III
Rubric: 15m Code + 5m Viva +
5m Record
MEDIUM
15 Marks
Session: 59:59
Bubblewrap Sandbox Active
Problem Statement
Write an SQL query using a correlated subquery to identify all employees whose salary strictly exceeds the average salary of their respective department.
Query Requirements:
1. Select columns: `emp_id`, `name`, `salary`, `dept_id`.
2. Filter condition: `salary > (SELECT AVG(salary) FROM employees WHERE dept_id = outer.dept_id)`.
3. Order results by `emp_id` ascending.
Click Run Code to evaluate against sample test
cases, or Submit Solution for full evaluation.
No compiler or execution errors recorded.
-- Write your SQL query here
SELECT e1.emp_id, e1.name, e1.salary, e1.dept_id
FROM employees e1
WHERE e1.salary > (
SELECT AVG(e2.salary)
FROM employees e2
WHERE e2.dept_id = e1.dept_id
)
ORDER BY e1.emp_id ASC;