Explore BrainMass

Explore BrainMass

    SQL Queries to Manipulate Tables

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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.

    © BrainMass Inc. brainmass.com April 3, 2020, 8:45 pm ad1c9bdddf


    Solution Summary

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