4.1 Your company wants to categorize employee salaries to determine who is eligible for a payraise 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 Consider the table belowstaffidName0001000200030004JOHNSONAndrewJohnsonMaryWage1500012000100008000AddressMidrandPretoriaDurbanCape Town Study the scenario and complete the questions that follow:Classification of WageAll classified employees are paid within a salary range determined by the job profile and job codeassigned when the position is created. An employee receives salary step increases in accordance withthe contract or rules covering the position until the employee reaches the top automatic step of thesalary range, after which there are no more automatic step increases.

The SQL Query is given below with output screenshot

Answered: Your company wants to categorize…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

4.1 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

Consider the table below
staffid
Name
0001
0002
0003
0004
JOHNSON
Andrew
Johnson
Mary
Wage
15000
12000
10000
8000
Address
Midrand
Pretoria
Durban
Cape Town

Transcribed Image Text:Study the scenario and complete the questions that follow: 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.

Expert Solution