DBI202Xuất hiện trong 1 đề thi
Suppose relation R(A, B, C, D) has the following tuples: | A | B | C | D | |---|---|---|------| | 1 | a | 101 | 1000 | | 2 | b | 102 | 1500 | | 3 | c | 101 | 1500 | | 4 | d | 101 | 2000 | | 5 | e | 102 | 1000 | | 6 | f | 101 | 3000 | | 7 | g | 101 | 4000 | Which tuple is contained in the result of the following query: ```sql SELECT C , AVG(D) FROM R GROUP BY C HAVING AVG(D) > 1000 ORDER BY C ```
Các lựa chọn
A(101 , 11500) , (102 , 2500)
B(101 , 2300) , (102 , 1250)
C(101 , 5) , (102 , 2)
D(101 , 11500) , (102 , 1250)