Using the database schema above write and execute the queries below and paste the screenshots of the result of each query below each question: 1. List the first name and last name of employee(s) who are supervised by "James Bord". Hint: Use inner query with IN operator. If there are duplications in the resultant list then use DISTINCT keyword in the SELECT clause of the outer query. 2. How many projects do the departments other than the administration department control? List the department name and the number of projects it controls. Hint: Use inner query with IN or NOT IN operator 3. What is the total salary paid to the employees working on the "Computerization" project? Hint: Use innter query with IN operator 4. What is the average salary paid to the employees working on the projects other than the project "ProductZ"? Hint: Use innter query with IN or NOT IN operator 5. List the first name and last name of employee(s) who are supervised by supervisors "James Bord" or "Franklin Wong"? Hint: Use set operator UNION