Employee ID Name Department Sales ($) Target ($) Region Q.1.
Ans
101 Alice Sales 2500 3000 East Below Target
102 Bob IT 1500 2000 West Below Target
103 Charlie Marketing 3000 3500 East Below Target
104 David IT 1800 2500 North Below Target
105 Eva Sales 4000 3000 South Above Target
106 Frank Marketing 2200 2500 West Below Target
107 Grace Sales 2700 2500 North Above Target
108 Henry Marketing 3500 4000 South Below Target
109 Aadhya Sales 1200 2500 North Below Target
110 Abhinav Marketing 3500 3000 South Above Target
111 Aryan IT 2700 2500 West Above Target
112 Tanvi IT 2300 2500 North Below Target
113 Riya Marketing 3500 4000 South Below Target
114 Saanvi Sales 2900 2000 North Above Target
115 Kiara Marketing 3600 3000 South Above Target
116 Meera IT 3100 3500 West Below Target
Q.1. For each employee, display "Above Target" if their sales are greater than or equal to the target, or "Below Ta
Q.2. For each employee, display:
"Excellent" if the sales are greater than or equal to 3500,
"Good" if sales are between 2500 and 3499,
"Needs Improvement" if sales are less than 2500.
Q.3. For each employee in the Sales department, display:
"High Sales" for sales greater than or equal to 3000,
"Medium Sales" for sales between 2000 and 2999,
"Low Sales" for sales below 2000.
Leave blank for employees not in the Sales department.
Q.4. How many employees have sales greater than or equal to 2500?
Ans: 11
Q.5. How many employees in the "Sales" department have sales greater than or equal to 2500 and are in the "Eas
Ans: 1
Q.6. What is the total sales for employees in the "Marketing" department?
Ans: 19300
Q.7. What is the total sales for employees who are in the "Sales" department and in the "East" region?
Ans: 2500
Q.8. What is the average sales for employees in the "Sales" department?
Ans: 2660
Q.9. What is the average sales for employees in the "Sales" department who have sales greater than or equal to 2
Ans: 3025
Q.2. Ans Q.3. Ans
Good Medium Sales
Needs Improvement Not Sales
Good Not Sales
Needs Improvement Not Sales
Excellent High Sales
Needs Improvement Not Sales
Good Medium Sales
Excellent Not Sales
Needs Improvement Low Sales
Excellent Not Sales
Good Not Sales
Needs Improvement Not Sales
Excellent Not Sales
Good Medium Sales
Excellent Not Sales
Good Not Sales
han or equal to the target, or "Below Target" if their sales are less than the target.
han or equal to 2500 and are in the "East" region?
ent and in the "East" region?
ho have sales greater than or equal to 2500?
Employee ID Name Department Sales ($) Target ($) Working Hours Region Q.1.
101 Alice Sales 3000 2500 40 East Target Achieved
102 Bob Sales 1800 2500 35 West Target Not Achieved
103 Charlie Marketing 3500 3000 40 East Target Achieved
104 David Sales 2300 2200 38 North Target Achieved
105 Eva Marketing 4500 4000 45 South Target Achieved
106 Frank Sales 2600 3000 42 West Target Not Achieved
107 Grace Marketing 2000 2500 40 North Target Not Achieved
108 Henry Sales 3200 3500 38 South Target Not Achieved
Q.1. For each employee, display "Target Achieved" if their sales are greater than or equal to the target, and "Targe
Q.2. For each employee, display "Excellent Performance" if their sales are greater than or equal to 3000 and their
Q.3. For each employee, display "Performance Review" if their sales are below 2000 or their working hours are les
Q.4. For each employee, display:
"Excellent" if their sales are greater than or equal to 4000,
"Good" if their sales are between 2500 and 3999, and
"Needs Improvement" if their sales are below 2500.
Q.5. For each employee, display:
"Top Performer" if their sales are greater than or equal to 3000 and their working hours are greater than or
"Average Performer" if their sales are between 2000 and 2999 and their working hours are between 30 and
"Underperformer" if their sales are below 2000 or their working hours are less than 30,
otherwise display "Yet to evaluate".
Q.6. For each employee, display:
"Under Review" if their sales are less than 2500 or their working hours are less than 38,
"Good Standing" otherwise.
Q.2. Q.3. Q.4. Q.5. Q.6.
Excellent Performance Meets Expectations Good Top Performer Good Standing
Needs Improvement Performance Review Needs Improvement Underperformer Under Review
Excellent Performance Meets Expectations Good Top Performer Good Standing
Needs Improvement Meets Expectations Needs Improvement Average Performer Under Review
Excellent Performance Meets Expectations Excellent Top Performer Good Standing
Needs Improvement Meets Expectations Good Yet to evaluate Good Standing
Needs Improvement Meets Expectations Needs Improvement Yet to evaluate Under Review
Needs Improvement Meets Expectations Good Yet to evaluate Good Standing
l to the target, and "Target Not Achieved" if their sales are below the target.
r equal to 3000 and their working hours are 40 or more, otherwise display "Needs Improvement."
heir working hours are less than 38, otherwise display "Meets Expectations."
hours are greater than or equal to 40,
ours are between 30 and 39,
