Amazon Marketing Cloud Certification
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.
Correct Answer
There is no GROUP BY statement; this query cannot be run without aggregation on the campaign dimension.