Problem
I. Write an SQL statement to create a view named DepartmentEmployeeProject-AssignmentView that shows the values of EMPLOYEE.LastName as EmployeeLastName, EMPLOYEE.FirstName as EmployeeFirstName, EMPLOYEE.OfficePhone as Employee-Phone, DEPARTMENT.DepartmentName, DEPARTMENT.Department-Phone as DepartmentPhone, and PROJECT.ProjectName as ProjectName. Run this statement to create the view, and then test the view by writing and running an appropriate SQL SELECT statement.
II. Write an SQL statement to create a view named ProjectHoursToDateView that shows the values of PROJECT.ProjectID, PROJECT.ProjectName, PROJECT.Max-Hours as ProjectMaxHours, and the sum of ASSIGNMENT.HoursWorked as ProjectHoursWorkedToDate. Run this statement to create the view, and then test the view by writing and running an appropriate SQL SELECT statement.