Explore BrainMass

Explore BrainMass

    Microsoft 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 GROUP statement:

    A. Group employees by salary within their job code: Select the employee's last name and group them by salary within their job_title_code.

    B. Select the employee's last name and group them by salary within job titles that are grouped into exempt and non-exempt.

    © BrainMass Inc. brainmass.com November 30, 2021, 12:13 am ad1c9bdddf
    https://brainmass.com/computer-science/sql/microsoft-sql-statements-28994

    Solution Preview

    Select Last_name, Salary,job_title_code from Employees
    group by ...

    Solution Summary

    Microsoft SQL STATEMENTS are included.

    $2.49

    ADVERTISEMENT