Neco 2017 Data Processing Question 41
Practice objective / multiple choice question 41 from the 2017 Neco Data Processing examination.
The company maintains a table Employees(EmpID, DeptID, Salary). In each department the employee with the highest Salary is the manager. Write an SQL query to list the DeptID values where the average Salary of the non‑manager staff exceeds \(0.8\) times the manager's Salary. Using the data below, how many departments satisfy the condition? Employees data: DeptID | EmpID | Salary (₦ thousands) 1 | 101 | 100 1 | 102 | 80 1 | 103 | 70 2 | 201 | 120 2 | 202 | 100 3 | 301 | 90 3 | 302 | 85 3 | 303 | 80 3 | 304 | 75 4 | 401 | 110 4 | 402 | 95 4 | 403 | 90 5 | 501 | 130 5 | 502 | 120 5 | 503 | 115 6 | 601 | 95 6 | 602 | 80
Answer Options
About This Question
This is Neco 2017 Data Processing Question 41. It is one of the objective questions from the 2017 Neco Data Processing examination.
Difficulty level: Medium .
Master the Exam!
You've seen a preview, but there are thousands more questions plus AI tutor to break down complex solutions.