Microsoft SQL Server 2000
Not what you're looking for?
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.
Purchase this Solution
Solution Summary
Microsoft SQL Server 2000 is emphasized in the solution.
Solution Preview
A. Calculate the average salary for all employees.
SELECT Avg(Salary) as Avgsalary FROM Employees;
B. Calculate the maximum salary for exempt employees and the maximum salary for non-exempt employees.
SELECT Max(Employees.Salary) AS MaxOfSalary, Job_title.Exempt_non_exempt_status FROM Employees, Job_title ...
Purchase this Solution
Free BrainMass Quizzes
Word 2010: Table of Contents
Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.
Java loops
This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.
C++ Operators
This quiz tests a student's knowledge about C++ operators.
Basic Computer Terms
We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.
Javscript Basics
Quiz on basics of javascript programming language.