I tried to include all fields list in the group by clause, and still receiving error 1807 (invalid group by clause).