Question: Answer the following query in SQL. a. Retrieve the names of all employees who work in the department that has the employee with the highest

 Answer the following query in SQL. a. Retrieve the names of

Answer the following query in SQL.

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 supervisors 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.

EMPLOYEE \begin{tabular}{|l|l|l|l|l|l|l|l|l|l|} \hline Fname & Minit & Lname & Ssn & Bdate & Address & Sex & Salary & Super_ssn & Dno \\ \hline \end{tabular} DEPARTMENT \begin{tabular}{|l|l|l|l|} \hline Dname & Dnumber & Mgr_ssn & Mgr_start_date \\ \hline \end{tabular} DEPT_LOCATIONS \begin{tabular}{|l|l|} \hline Dnumber & Dlocation \\ \hline \end{tabular} PROJECT \begin{tabular}{|l|l|l|l|} \hline Pname & Pnumber & Plocation & Dnum \\ \hline \end{tabular} WORKS_ON \begin{tabular}{|l|l|l|} \hline Essn & Pno & Hours \\ \hline \end{tabular} DEPENDENT \begin{tabular}{|l|l|l|l|l|} \hline Essn & Dependent_name & Sex & Bdate & Relationship \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!