I thought max(count()) should be performed on the seperate groups of rows returned from GROUP BY deptno.
However, it seems that count() is performed based on GROUP BY while max() is performed upon the result of count() .. GROUP BY.
select max(count(deptno)) from emp group by deptno;
Why is this? How does nested group functions work against the GROUP BY?