Scribd
Upload
1 views1 page

SQL Lab 6 Subqueries-1

The document outlines a series of SQL exercises using the Employees Database from Laboratory 1. It includes tasks such as finding employees in the Consulting department, identifying those who spend a certain percentage of time on a specific project, and querying information about departments and salaries. Each exercise requires a single SQL statement that is applicable to any dataset within the Employees Database.

Uploaded by

menardcristobas96
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
1 views1 page

SQL Lab 6 Subqueries-1

The document outlines a series of SQL exercises using the Employees Database from Laboratory 1. It includes tasks such as finding employees in the Consulting department, identifying those who spend a certain percentage of time on a specific project, and querying information about departments and salaries. Each exercise requires a single SQL statement that is applicable to any dataset within the Employees Database.

Uploaded by

menardcristobas96
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Lab 6: Subqueries

For these exercises, we use the Employees Database created in Laboratory 1. Answer
each question with a single SQL statement. Your query must work for any set of data in
the Employees Database, not just the set of data we provide.

1. Find the names of all people who work in the Consulting department.
2. Find the names of all people who work in the Consulting department and who
spend more than 20% of their time on the project with ID ADT4MFIA.
3. Find the names of all departments not currently assigned a project.
4. Find the first and last names of all employees who make more than the average
salary of the people in the Accounting department.
5. Find the minimum salary of the employees who are paid more than everyone in
the Accounting department.
6. Find all departments where all of their employees are assigned to all of their
projects.

You might also like