Sql: the output of the querry


#1

the output???


#2

my ans is 2.6… but still have doubt


#3

Output: Error…

Wrong Query.


#4

SELECT AVG(E.Num) FROM (SELECT DeptName,COUNT(EmpId) AS Num FROM 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.