Answer (Choose 1 answer)
A Suppose relation R(A, B, C) has the following tuples (see figure)
Which tuple is contained in the result of the following query:C
SELECT A. COUNT(DISTINCT B)FROM R
33 3 3
4
5
1
GROUP BY A HAVING SUM(B) >3:
A. (3.12)
B. (2.3)
C. (3.7)
D. (2.10)
1
1
2
2
2
3
3
1
2
1
3
4
2
3
46
the exam.
3
