Error 1055 ONLY FULL GROUP BY something is not in GROUP BY clause ...

Misusing GROUP BY to return unpredictable results Murphys Law

Misusing GROUP BY with SELECT and how to fix it

Using and misusing GROUP BY

ANY VALUE