C is the correct answer.
This groups the table by the "Item" column, sums the "Quantity" for each group (item), and then finds the maximum sum. This is correct.
A is incorrect because this returns the maximum individual "Quantity" value from the table, not the total per item.
The question is quite tricky.
We are going to get 80 for both option A and C but here is why C is right.
The question is asking for the maximum of the total quantities.
In this case, option A just gives as the maximum individual quantity in the quantity column which is Kiwi giving 80.
In the case of option C, which answers the question, it groups each of the quantity of items(apple, orange, mango, kiwi, pear).
It goes ahead to sum them (apple - 10+5+12=27, orange-20, mango-5+15=20,kiwi=80,pear=1).
It finds the maximum of the sums (27, 20, 20, 80, 1). In this case, 80 is the maximum of the total quantities.
The answer is A. I tested it in studio, it returned the value of 80. Which is the largest value in the "Quantity" column
upvoted 1 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
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.
Kartik_K
1 month, 1 week agoBenAndBen
4 months, 1 week agokingkayy
7 months, 1 week agoBenAndBen
4 months, 1 week agomilindkumar
8 months, 4 weeks agomilindkumar
8 months, 4 weeks agoChoudayya
8 months, 4 weeks agoBrandon00777
9 months agoBrandon00777
9 months ago