City Guilds Model Questions Vol1 2018 Information Technology Question 40
Practice objective / multiple choice question 40 from the 2018 City Guilds Model Questions Vol1 Information Technology examination.
The table EMPLOYEE has columns EmpID, Dept, and Salary. The data are: | EmpID | Dept | Salary | |------|-------|--------| | 1 | Sales | 50000 | | 2 | Sales | 55000 | | 3 | HR | 48000 | | 4 | HR | 47000 | | 5 | HR | 50000 | | 6 | IT | 60000 | What is the average salary (to two decimal places) of the department(s) that have the highest number of employees?
Answer Options
About This Question
This is City Guilds Model Questions Vol1 2018 Information Technology Question 40. It is one of the objective questions from the 2018 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.