Hi this is what I need: "Display the name and salary of all employees working on the same Department than 'Mike'. The result shouldn't include 'Mike' "
So I have this query:
SELECT E.Name,E.Salary FROM E WHERE E.DepWorking = (SELECT DepWorking FROM E WHERE Name = 'Mike');
And an additional condition in the WHERE
clause:
SELECT
E.Name,E.Salary
FROM E
WHERE
E.DepWorking IN (SELECT DepWorking FROM E WHERE Name = 'Mike')
AND E.Name <> 'Mike'
;