Consider the following relation: Employee(EmpID, Name, Department, Salary) Write an SQL query to retrieve the Department, the total number of…
Consider the following relation:
Employee(EmpID, Name, Department, Salary)
Write an SQL query to retrieve the Department, the total number of employees, and the average salary for each department. The output should display one record for each department.
From the Combined Bank Senior Officer July 2026 – Written exam, question 62 of 73.