Comprehension Passage
Consider the following relations A, B and C:
|
A |
||
|
Id |
Name |
Age |
|
12 |
Arun |
60 |
|
15 |
Shreya |
24 |
|
99 |
Rohit |
11 |
|
B |
||
|
Id |
Name |
Age |
|
15 |
Shreya |
24 |
|
25 |
Hari |
40 |
|
98 |
Rohit |
20 |
|
99 |
Rohit |
11 |
|
C |
||
|
Id |
Phone |
Area |
|
10 |
2200 |
02 |
|
99 |
2100 |
01 |
How many tuples does the result of the following SQL query contain?
SELECT A.Id
FROM A
WHERE A.Age > ALL (SELECT B.Age
FROM B WHERE B.Name = ‘Arun’)
1
4
2
3
3
0
4
1