Why would this query fail?
SELECT campaign,
SUM(impressions) AS impressions
FROM dsp_impressions
- There is no GROUP BY statement; this query cannot be run without aggregation on the campaign dimension.
- There is no WHERE clause to filter the query results based on one or more conditions.
- SELECT statements can not be used to choose metrics from a table.