ecify the following views in SQL, on the COMPANY database schema shown in Figure 5.5 . A view that has the department name, manager name, and manager sal- ary for every department A view that has the employee name, supervisor name, and employee sal- he Research department c. A view that has the project name, controlling department name, number of employees, and total hours worked per week on the project for each project d. A view that has the project name, controlling department name, number of employees, and total hours worked per week on the project for each project with more than one employee working on it