Suppose relation R(a,b,c) has the following tuples:
A B C
-----------------------------------
1 1 3
1 2 3
2 1 4
2 3 5
2 4 1
3 2 4
3 3 6
Which tuple is contained in the result of the following query:
SELECT a, COUNT(DISTINCT B) FROM R
GROUP BY a
HAVING SUM(B) >3;
A.(2,10)
B.(3,7)
C.(2,3)
D.(3,12)
Answer: C