Select list cannot mix columns and aggregate functions without
  GROUP BY

  Explanation:  The select list in a select expression without a
  GROUP BY clause cannot include both aggregate functions and
  column references which are not within aggregate functions.

  User Action:  Either add a GROUP BY clause, remove the aggregate
  function references, or remove the column references that are
  not in aggregate functions.