无效使用组

Question

i've been trying to do this on php, reading from a db table in mysql, but i cant understand what's the error on it. can someon help me please? the table as a column that contains numbers (this numbers represent a course :P)

SELECT *, MAX(COUNT(mi_curso)) maximo
FROM producto
GROUP BY mi_curso

and this is the error shown:

consulta SQL:
SELECT *, MAX(COUNT(mi_curso)) maximo
FROM producto
GROUP BY mi_curso LIMIT 0, 25

MySQL ha dicho: Documentación 
#1111 - Invalid use of group function

Answer 1

could you try the following and comment if this worked?

SELECT id, COUNT(mi_curso) maximo FROM producto GROUP BY mi_curso having max(count(mi_curso))

edit: as suggested by Tim Biegeleisen

SELECT id, COUNT(mi_curso) maximo FROM producto GROUP BY mi_curso having max(count(maximo))