A data analyst is processing a complex aggregation on a table with zero null values and the query returns the following result: Which query did the analyst execute in order to get this result?

Select an option, then click Submit answer.
Reference / correct answer:
Most accepted answer: C.
Community votes: C=3
Selected Answer: C It is not CUBE A CUBE(group1, group2) must generate all possible combinations of the grouping columns: (group1, group2) (group1, NULL) (NULL, group2) (NULL, NULL) Since the result does not include: (NULL, Y) (NULL, Z) it cannot be a CUBE. upvoted 1 times
Selected Answer: C c is correct upvoted 1 times
Selected Answer: C There are no totals for group_2 here (group_1=null). Therefore, it is ROLLUP upvoted 1 times