How do you do 5.7, parts a, b, and c?

Schema:

5.7 In SQL, specify the following queries on the database in Figure 3.5 using the concept of nested queries and concepts described in this chapter. a. Retrieve the names of all emplovees who work in the department that has the employee with the highest salary among all employees b. Retrieve the names of all employees whose supervisor's supervisor has '888665555' for Ssn. 42 Chapter 5 More SQL: Complex Queries, Triggers, Views, and Schema Modification c. Retrieve the names of employees who make at least $10,000 more than the employee who is paid the least in the company