Computer Science Homework Solutions
Problem
#28994

Microsoft SQL STATEMENTS

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.  

Solution
What is this?
By OTA - Overall OTA Rating
Marcia Wert, MS - 4.1/5
Purchase Cost Now
$2.19 CAD (was ~$7.98)
Included in Download
  • Plain text response
$2.19 Instant Download
Add to Cart
Why you can trust BrainMass.com
  • Your Information is Secure
  • Best Online Academic Help Service
  • Students find real academic Success
Related Solutions
  • MS SQL STATEMENT PROBLEMS - 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_ar ...
  • MS SQL STATEMENTS - I am using Microsoft SQL Server 2000 1. Database Tables TABLE: Employees Job_title_code Social_security_number Last_name First_name Address City Sta ...
  • SQL QUERIES - I am using MS SQL SERVER 2000 (I have the database built), I would like to run these quieries. Using the database and tables write SQL queries using BETWEEN, LIKE and UNION: 1. Write a SQL que ...
  • MS SERVER SQL SCRIPT PROBLEMS/MS SQL SERVER 2003 - 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. Cho ...
  • SQL Statements To Run In SQl Server - write SQL queries using Between, Like and Union: • Write a SQL query that joins two tables in the example database and uses BETWEEN to restrict record selection. (Use salary to restrict the d ...
Browse