Posted on

Why would this query fail? SELECT campaign, SUM(impressions) AS impressions FROM dsp_impressions

  • SELECT statements can not be used to choose metrics from a table.
  • There is no WHERE clause to filter the query results based on one or more conditions.
  • There is no GROUP BY statement; this query cannot be run without aggregation on the campaign dimension.

The correct answer is:

  • There is no GROUP BY statement; this query cannot be run without aggregation on the campaign dimension.