Neco 2020 Data Processing Question 5
Practice objective / multiple choice question 5 from the 2020 Neco Data Processing examination.
The following tables store information about a company.\n\nEmployees(EmpID, DeptID, Salary)\n\nDeptID | DeptName | ManagerID\n1 | Administration | 10\n2 | Sales | 12\n3 | Research | 15\n\nThe Employees table contains these records:\n\nEmpID DeptID Salary\n101 1 5000\n102 1 6000\n103 1 5500\n201 2 4000\n202 2 4500\n203 2 4200\n204 2 4600\n301 3 7000\n302 3 8000\n303 3 7500\n304 3 7200\n305 3 7700\n\nFind the name of the department whose average employee salary is greater than the overall average salary of the company and that has more than three employees.
Answer Options
About This Question
This is Neco 2020 Data Processing Question 5. It is one of the objective questions from the 2020 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.