Compute the minimum salary for all employees

Assignment Help Computer Engineering

Reference no: EM1333493

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.

Reference no: EM1333493

Questions Cloud

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

Explain any other differences among selling the mobility : Explain any other differences among selling the mobility product in the United States and selling it in your three targeted countries.

Simple regression between walk times and cholesterol levels : A health researcher is interested in determining whether or not the speed at which people, a simple regression between the walk times and the cholesterol levels

Layoff practices causing for succession planning : To be a true strategic partner, does HR need to take on a more generalized or specialized approach to work and What problems are demographic shifts and layoff practices causing for Succession Planning

Compute the minimum salary for all employees : compute the maximum salary for exempt employees and the maximum salary for non-exempt employees.

Describe the two approaches of make or buy : Describe the two approaches of "make or buy" in regards to developing required competencies, in context of human resource development and organizational change management.

Explain brick and mortar versus online travel agencies : Explain Brick and Mortar versus Online Travel Agencies and Explain how the supply chain was modified from brick and mortar

Illustrate what does the law of increasing opportunity price : Illustrate what does the law of increasing opportunity price say and what is its implications regarding steel and textile manufacturing.

Create incentives for change by keeping score : From the Discussion section or the BSC literature, what are good criteria to evaluate the BSC measures and How well does the draft scorecard meet the criteria that were stated

User Account

All Pages