SELECT employee_number, name FROM employees emp WHERE salary > ( SELECT AVG(salary) FROM employees WHERE department = emp.department);
Without correlated subquery: https://en.wikipedia.org/wiki/Correlated_subquery
17 + 1 =
Your Email
Your Name
Enter the destination URL
Or link to existing content