Neco 2025 Data Processing Question 29
Practice objective / multiple choice question 29 from the 2025 Neco Data Processing examination.
Given the tables:\n\nEmployees(EmpID, DeptID, Salary)\n\nDepartments(DeptID, ManagerID, Budget)\n\nData:\nEmployees: (1,10,50000), (2,10,60000), (3,20,40000), (4,20,45000), (5,30,70000)\nDepartments: (10,101,200000), (20,102,120000), (30,103,80000)\n\nWrite an SQL query that lists the DeptID of departments where the average employee salary exceeds 75\% of the department budget. Also state which indexes would most improve the performance of this query.
Answer Options
About This Question
This is Neco 2025 Data Processing Question 29. It is one of the objective questions from the 2025 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.