Purchase Solution

Sql Queries for Employees, Salary, Job tables

Not what you're looking for?

Ask Custom Question

Need help quickly with some SQL queries. I am using SQL 2005 express.
Please help.

Using the database, tables, and data, write SQL statements to:
? Calculate the average salary for employees for each state.
? Calculate the maximum salary for exempt employees and the maximum salary for non-exempt employees.
? Calculate the maximum salary for all employees whose hire_date is between two dates.
? Calculate the maximum salary for employees within each job class
? Calculate the minimum salary for exempt employees and the maximum salary for non-exempt employees.
? Calculate the total salary for employees separated by gender within each job class
? Determine the oldest and youngest employees and provide the age for each category.
? Determine what percent of the largest salary is used for the total payroll in the company.

Attachments
Purchase this Solution

Solution Summary

The solution contains a complete SQL script for the required queries.

Solution Preview

Find attached the file with sql queries. Example.

-- Calculate the average salary for employees for each state.
SELECT state, AVG(salary) as ...

Purchase this Solution


Free BrainMass Quizzes
Word 2010: Tables

Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.

Excel Introductory Quiz

This quiz tests your knowledge of basics of MS-Excel.

C++ Operators

This quiz tests a student's knowledge about C++ operators.

Javscript Basics

Quiz on basics of javascript programming language.

C# variables and classes

This quiz contains questions about C# classes and variables.