Question: c ) ( 5 pts ) Let R ( A , B , C , D ) be a relation with attribute A as its

c)(5 pts) Let R (A,B,C,D) be a relation with attribute A as its primary key. Let |R| be the
number of tuples in R. Consider the following query:
Select D, Min(C)
From R
Group by D
It is known that there are 20 different values for attribute D, and than 90% of the values
of C a greater than 21. What is the number of values that this SQL can return?
I. 20
II.18
III. 2
IV.0
V. Cannot be determined

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!