Computer Science Homework Solutions
Problem
#29126

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_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. Write SQL statements to:

A. Calculate the average salary for all employees.

B. Calculate the maximum salary for exempt employees and the maximum salary for non-exempt employees.

C. Calculate the maximum salary for all employees.

D. Calculate the minimum salary for exempt employees and the maximum salary for non-exempt employees.

E. Calculate the minimum salary for all employees.

Solution
What is this?
By OTA - Overall OTA Rating
Shawn Laliberte - 4.8/5
Purchase Cost Now
$2.19 CAD (was ~$15.96)
Included in Download
  • Plain text response
  • Attached file(s):
    • 29126sol.doc
$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
  • 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 Sta ...
  • 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