A data analyst is processing a complex aggregation on a table with zero null values and their query returns the following result: Which of the following queries did the analyst run to obtain the above result?
All the answers provided are incorrect. I don't think it was copied correctly. The correct answer should be below which is closest to option E.
SELECT group_1, group_2, SUM(values) AS sum
FROM my_table
GROUP BY group_1, group_2 WITH CUBE;
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
MrWood47
Highly Voted 9 months, 1 week ago