Explore BrainMass

Explore BrainMass

    MS SERVER SQL SCRIPT PROBLEMS/MS SQL SERVER 2003

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

    Using the database and tables from attached document, write queries using the SQL SELECT statement.
    (Note: Select all of the data from both of your tables before you perform the following)

    1. Choose a job_title_code: Increase all employees' salaries that have:
    job_title_code by 10%.

    SELECT * from Job_title,Employees;
    UPDATE Employees
    SET Salary = Salary + (Salary * .10)
    WHERE job_title_code = ;

    2. Choose a job_title_code in the job_title table. Increase the
    Minimum_salary and Maximum_salary for this job_title_code.

    SELECT * from Job_title,Employees;
    UPDATE Job_title
    SET Minimum_salary = Minimum Salary + 10
    WHERE job_title_code = ;

    3. Increase all employees' salaries by 5%.

    SELECT * from Job_title,Employees;
    UPDATE Employees
    SET Salary = Salary + (Salary * .05);

    4. Choose an employee from the employee table, delete this employee.

    DELETE from Employees
    WHERE employees = ;

    These problems currently have errors and will not run. Please fix

    © BrainMass Inc. brainmass.com February 24, 2021, 2:34 pm ad1c9bdddf
    https://brainmass.com/computer-science/sql/ms-server-sql-script-problems-ms-sql-server-2003-29936

    Attachments

    Solution Summary

    MS SERVER SQL SCRIPT PROBLEMS/MS SQL SERVER 2003 are solved.

    $2.19

    ADVERTISEMENT