Specify the following views in SQL on the COMPANY database schema shown in Figure 3. A view that has the department name, manager name, and manager...

Specify the following views in SQL on the COMPANY database schema shown in Figure 3.5.a. A view that has the department name, manager name, and manager salary for every department.b. A view that has the employee name, supervisor name, and employee salary for each employeewho works in the ‘Research’ department.c. A view that has the project name, controlling department name, number of employees, and totalhours worked per week on the project for each project.d. A view that has the project name, controlling department name, numberof employees, and total hours worked per week on the project for eachproject with more than one employee working on it