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 SUM(D)
FROM S
WHERE D < 8 AND D > 5
Choose the row that appears in the computed result.
a. 6
b. 7
c. 8
d. 9
Answer: A