What row that appears in the result of the following query: SELECT SUM(C), SUM(D) FROM S WHERE D < 9 AND D > 5

What row that appears in the result of the following query: SELECT SUM(C), SUM(D) FROM S WHERE D < 9 AND D > 5

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

What row that appears in the result of the following query:
SELECT SUM(C), SUM(D)
FROM S
WHERE D < 9 AND D > 5 



a. (10,11)
b. (10,12)
c. (10,13)
d. (10,14)




Answer: D


Learn More :