Scalar subquery for comparison
SQL
Easy
3 views
Problem Description
Find employees whose salary is above the company average salary.
Official Solution
SELECT emp_id, name, salary FROM Employees WHERE salary > (SELECT AVG(salary) FROM Employees);
Solutions (0)
No solutions submitted yet. Be the first!
No comments yet. Start the discussion!