Question: 50
(Choose 1 answer)
Suppose relation R(A, B, C, D) has the following tuples:
ABCD
1 a 101 1000
2 b 102 1500
3 c 101 1500
4 d 101 2000
5 e 102 1000
6f 101 3000
7 g 101 4000
Which tuple is contained in the result of the following query:
SELECT C, AVG(D)
FROM R
GROUP BY C
HAVING AVG(D) > 1000
ORDER BY C
A. (101, 11500); (102, 2500)
B. (101, 2300); (102, 1250)
C. (101, 5) (102, 2)
D. (101, 11500); (102, 1250)
