All MySQL error codes

MySQL error code

MySQL error 1111

MySQL server error 1111 is ER_INVALID_GROUP_FUNC_USE, reported with SQLSTATE HY000.

Invalid use of group function

Error	1111
Name	ER_INVALID_GROUP_FUNC_USE
SQLSTATE	HY000
Group	Server errors

How to fix it

Explained step by step, with a query you can run

aggregate function calls cannot be nested

Explained step by step, with a query you can run

aggregate functions are not allowed in WHERE

In other databases

Source: MySQL 8.4 Error Reference