SELECT E.EmpFname, E.EmpLname, P.EmpPosition FROM EmployeeInfo E INNER JOIN EmployeePosition P ON E.EmpID = P.EmpID AND P.EmpPosition IN ('Manager');
This query will give
Afetch all employees who also hold the managerial position from inner join operation on employeeInfo and EmployeePositionCorrect AnswerIncorrect Answer
Bfetch all employees who also does not hold the managerial position from inner join operation on employeeInfo and EmployeePositionCorrect AnswerIncorrect Answer
Cfetch all employees who also hold the managerial position from outer join operation on employeeInfo and EmployeePositionCorrect AnswerIncorrect Answer
Dfetch Top employees who also hold the managerial position from inner join operation on employeeInfo and EmployeePositionCorrect AnswerIncorrect Answer