This view definition must explicitly list column names

  Explanation:  You must specify names for all the columns in a
  view if the select expression in the view definition uses
  aggregate functions or arithmetic expressions to create columns
  not in the source tables.

  User Action:  Explicitly name each coulumn in the view
  definition.