Explore BrainMass

SQL Queries to Manipulate Tables

Please refer to the attached file SQL1.txt that contains SQL commands to create two tables Employee and Job_Title, and populate them with data.

Write SQL queries to accomplish following.

1. Choose a Job Description and increase by 10% all employees' salaries that have the selected Job Description (not Job Title).

2. Decrease all Exempt employees' salaries from a certain State by 15%.

3. Increase all Non-Exempt employees' salaries by 5%, if employee was hired more than 3 years ago and is less than 30 years of Age.

4. Delete Exempt employees earning a Salary greater than a certain amount.

5. Calculate the maximum salary of all Exempt employees.

6. Calculate the minimum, maximum, and average salary for each Job_Description.

7. Insert 3 additional Job_Title records that no Employee holds.
Write a Select query that displays ALL Job_Descriptions and the first and last name of anyone holding that description. The query MUST show all Job_descriptions, including the 3 additional just added.


Solution Summary

This solution provides a detailed tutorial of the given computer science problem.