Multisoft systems interview question

How would you solve the mysql issue when using some group aggregrate functions?