Create and test a view called EmployeeDepartmentDataView that contains the employee name concatenated and formatted as LastName, FirstName in a field named EmployeeName, EMPLOYEE.Department, DEPARTMENT.OfficeNumber,DEPARTMENT.Phone as DepartmentPhone, and EMPLOYEE.Phone as EmployeePhone. Run this statement to create the view, and then test the view by writing and running an appropriate SQL SELECT statement.