Who is eligible for pay raise based on their current salary

Assignment Help Computer Engineering

Reference no: EM133324787

Assignment: Classification of Wage All classified employees are paid within a salary range determined by the job profile and job code assigned when the position is created. An employee receives salary step increases in accordance with the contract or rules covering the position until the employee reaches the top automatic step of the salary range, after which there are no more automatic step increases. Question Your company wants to categorize employee salaries to determine who is eligible for a pay raise based on their current salary. Below are the conditions.

• Less than 10,000 is classify as a low wage.

• Between 10,000 and 20,000, is classify as a medium wage, and

• Above 20,000, is classify as a high wage. Write an SQL query to implement this using the stafflist table. 4.2 Consider the table below staffid Name Wage Address 0001 JOHNSON 15000 Midrand 0002 Andrew 12000 Pretoria 0003 Johnson 10000 Durban 0004 Mary 8000 Cape Town In the given table, there two similar names (JOHNSON and Johnson). Assume you are required to retrieve all the staff with name 'Johnson' or 'JOHNSON' in the stafflist table. Write SQL query to perform the task using UPPER and LOWER keywords.

Reference no: EM133324787

Questions Cloud

Discuss the role government plays in a global economy : Discuss the role government plays in a global economy. Also, look at what policies are currently in place and then discussion what policies should be put

Designing the application layer include a saas building : Designing the Application Layer Include a Saas building block that is connected to the Application Development Server Node in the Technology layer.

Explain how a persons needs may change : Explain how a persons needs may change over time while receiving palliative care and identify two ways that a care worker can support the person, carers

Identification of residents with polypharmacy : Identification of residents with polypharmacy and The percentage rate of residents with polypharmacy and antipsychotic use) -The nursing facility will reduce

Who is eligible for pay raise based on their current salary : Your company wants to categorize employee salaries to determine who is eligible for a pay raise based on their current salary. Below are the conditions.

The infusion pump to deliver how many ml : The nurse should program the infusion pump to deliver how many ml/hr - The healthcare provider prescribed an IV solution of isoproterenol 1mg in 250ml of D5W

What is the phenomenon of concern in hildegar : What is the phenomenon of concern in Hildegar Peplau's Theory of Interpersonal Relations? (Explain most relevant phenomenon of concern in this theory)

Why is hildegar peplaus theory of interpersonal relations : Why is Hildegar Peplau's Theory of Interpersonal Relations considered a middle-range theory?

How would you proceed with the clients care : NSG 5907 South College How would you proceed with the client's care in this case? What other professionals would you consider including in the care/treatment

User Account

All Pages