Nesting SELECT Statements › Things to Remember about Subqueries › Scenarios

Scenarios

Create the appropriate statements online to retrieve the needed data:

1. For tax purposes, the Accounting department needs to keep track of all jobs for which employees earn more than $65,000. A list of job titles is sufficient. (Use the JOB and POSITION tables.)
2. Upper management is concerned about the equality of salaries within Commonwealth Auto. They need to have a list by name of all jobs for which at least one employee earns less than $35,000. (Use the JOB and POSITION tables.)
3. Over the years, lots of department information has been added to the database. The Human Resources department is responsible for this portion of the database and knows that there are some departments still listed for which there are no longer any associated employees. They have asked you for a list showing these departments. Order the list by department ID. (Use the DEPARTMENT and EMPLOYEE tables.)

To check your answers, see Review Answers for Chapter 7