Crowdly
Add to Chrome
Consider the following relation and SQL query Tables: EMPLOYEE(EmpID, Name, ...
✅ The verified answer to this question is available below. Our community-reviewed solutions help you understand the material better.
Consider the following relation and SQL query
Tables:EMPLOYEE(EmpID, Name, DeptID, Salary)DEPARTMENT(DeptID, DeptName)
SQL Query:
SELECT e.Name
FROM EMPLOYEE e
WHERE Salary > (
SELECT AVG(Salary)
FROM EMPLOYEE
WHERE DeptID = e.DeptID
);
What does this query return?
❌
✅
❌