City Guilds Model Questions Vol1 2022 Information Technology Question 38
Practice objective / multiple choice question 38 from the 2022 City Guilds Model Questions Vol1 Information Technology examination.
The following tables store company data.\n\nEmployees(EmpID, DeptID, Salary):\n(1,10,5000), (2,10,6000), (3,10,5500), (4,20,7000), (5,20,7200), (6,20,6800), (7,20,7100), (8,20,6900), (9,30,4000), (10,30,4200)\n\nDepartments(DeptID, ManagerID):\n(10,1), (20,4), (30,9)\n\nHow many departments have an average salary that is at least 10% higher than the overall average salary of all employees?
Answer Options
About This Question
This is City Guilds Model Questions Vol1 2022 Information Technology Question 38. It is one of the objective questions from the 2022 City Guilds Model Questions Vol1 Information Technology 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.