Given these two tables:

Departinent

Employes

$\backslash$table$[[-$ Codo,DeparmeniName,oManagoriD$],[44,$Enpineering,$2538],[82,$Sales,$2539],[12,$Marketing,$6381],[99,$Tochnical support,$6381]]$

We create a view as below:

ManagerView

$\backslash$table$[[$DepartmentName$,$ManagerName$],[$Engineering$,$Lisa Ellison$],[$Sales$,$Lisa Ellison$],[$Marketing$,$Maria Rodriguez$],[$Technical support,Maria Rodriguez$]]$

Which is the correct code to create this Siew?

CREATE Manager VIEW

AS SELECT Department, Employee AS Marigurname

FROM Department. Employee

WHERE ManageriO $-$ EmployeeID:

CREATE VIEW ManagerView

AS SELECT Departmentitame EmployeeName AS Managerthame

FROM Department. Employee

WHERE ManagerD $-$ EmployeelD :

CREATE Manager VIEW

AS SELECI Departmentiname Employeename AS Managenthame

FROM Department. Employee

WHERE ManagerL $-$ EmployeeID :

CREAIE VIEW ManagerVIEW

AS SELECI Department, Employee AS Manager Name

FROM Department. Employee

WHERE ManagerD $-$ EmployeelD :