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

Justin Foley
November 25, 2023
Amazon Marketing Cloud Certification Answers

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.