my ans is 2.6… but still have doubt
SELECT AVG(E.Num) FROM (SELECT DeptName,COUNT(EmpId) AS
EMP GROUP BY DeptName) as E;
This is the correct query to yield the answer 2.6
The query in the question won’t work.