A.
select DepartmentID,avg(Salary) from Employee group by Salary
B.
select DepartmentID,avg(Salary) from Employee order by Salary
C.
select DepartmentID,avg(Salary) from Employee group by DepartmentID
D.
select DepartmentID,avg(Salary) from Employee order by DepartmentID