Explore BrainMass

Explore BrainMass

    MS SQL STATEMENTS

    Not what you're looking for? Search our solutions OR ask your own Custom question.

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

    I am using Microsoft SQL Server 2000

    1. Database Tables

    TABLE: Employees

    Job_title_code
    Social_security_number
    Last_name
    First_name
    Address
    City
    State
    Zip_code
    Telephone_area_code
    Telephone_number
    Email_address
    Hire_date
    Salary

    TABLE: Job_title

    Job_title_code
    Job_title
    Exempt_non_exempt_status
    Minimum_salary
    Maximum_salary

    2. Queries using the SQL SELECT statement.
    (Note: Select all of the data from both of your tables before you perform the following)

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

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

    C. Increase all employees' salaries by 5%.

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

    © BrainMass Inc. brainmass.com March 4, 2021, 6:06 pm ad1c9bdddf
    https://brainmass.com/computer-science/databases/ms-sql-statements-29123

    Solution Preview

    Select * from Job_title,Employees;
    a.
    Update Employees
    Set Salary = Salary + (Salary * .10)
    WHERE job_title_code = \"a\"; I don\'t know an example ...

    $2.49

    ADVERTISEMENT