GROUP BY anything but a column is illegal

  Explanation:  You have tried to specify something other than a
  column reference in a GROUP BY list.

  User Action:  Specify only columns in the GROUP BY list.