the error states the problem, you are including columns by way of the * that are not part of the group by statement