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
SELECT B, SUM(C)
FROM S
GROUP BY B
a. (c,11)
b. (c,13)
c. (c,12)
d. (c,18)
Answer: D
B C D
------------------------------------
a 4 6
c 6 8
c 5 5
e 9 9
F 10 10
c 7 9
Which one of the followings will appear in the result of the following query:
SELECT B, SUM(C)
FROM S
GROUP BY B
a. (c,11)
b. (c,13)
c. (c,12)
d. (c,18)
Answer: D