GROUP BY is not allowed in queries moved by CREATE TRANSFER

  Explanation:  The user entered a GROUP BY clause in a query as
  part of a CREATE TRANSFER statement.

  User Action:  Re-enter the statement without the GROUP BY
  clause.