Which query returns names of employees who work in the same department as 'Alice'?

Question

Accepted Answer

SELECT Name FROM Employees WHERE Name != 'Alice' AND Department = (SELECT Department FROM Employees WHERE Name = 'Alice');

Answer

SELECT Name FROM Employees WHERE Department = (SELECT Department FROM Employees);

Answer

SELECT Name FROM Employees WHERE Department = ALL (SELECT Department FROM Employees WHERE Name = 'Alice');

Answer

SELECT Name FROM Employees WHERE Department = (SELECT Department FROM Employees WHERE Name = 'Alice');

Crowdly