Suppose the relation S(B,C,D) has tuples:
B C D
-----------------------------------
a 4 6
c 6 8
c 5 5
e 9 9
f 10 10
c 7 9
Compute the result of the following query:
SELECT D, SUM(C)
FROM S
GROUP BY D
Choose rows that are appear in the computed result
a. (9,12)
b. (9,14)
c. (9,16)
d. (9,18)
Answer: C