In SQL, specify the following queries on the database in Figure 5.5 using the concept of nested queries and other concepts described in this chapter.

a. Retrieve the names of all employees 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.

c. Retrieve the names of employees who make at least $10,000 more than the employee who is paid the least in the company.

Figure 5.5:

Transcribed Image Text:

ΕMPLOYEΕ Minit Lname Ssn Sex Salary Super_ssn Dno Fname Bdate Address DEPARTMENT Dname Dnumber Mgr_ssn Mgr_start_date DEPT LOCATIONS Dnumber Dlocation PROJECT Pname Pnumber Plocation Dnum WORKS ON Essn Pno Hours Figure 5.5 Schema diagram for the DEPENDENT COMPANY relational Essn Dependent_name Sex Bdate Relationship database schema.