Question: Write SQL queries for this database Create the following queries on the COMPANY database and show their results . Here is my database https://www.mediafire.com/file/7g9p5hb1h3mkmm2/COMPANY_1.txt 5.For

Write SQL queries for this database

Create the following queries on the COMPANY database and show their results.

Here is my database https://www.mediafire.com/file/7g9p5hb1h3mkmm2/COMPANY_1.txt

5.For each project, retrieve the project name, controlling department name, number of employees, and total hours worked per week on the project.

6.Use nested query to: Retrieve the names of all employees who work in the department that has the employee with the highest salary among all employees.

7.Use nested query to: Retrieve the names of all employees whose supervisors supervisor has '888665555' for Ssn.

8.Use nested query to: Retrieve the names of employees who make at least $10,000 more than the employee who is paid the least in the company.

PLEASE MAKE SURE YOU SHOW THE RESULT FROM THAT REAL DATABASE. Hopefully, aslo check the syntax.

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!