Re: Invalid use of group function

[Peter Brawley]

To fix the syntax error, lose the Group By call in the subquery---it must return just a single value.

Simpler way to find the dept_no with the highest count ...

select dept_no, count(*) as N
from emple
group by N
order by N desc limit 1;