Consider the following relations $A$, $B$ and $C$: 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. Evaluate the subquery: ```sql SELECT B.Age FROM B WHERE B.Name = 'Arun' ``` Looking at relation $B$, the distinct values of Name are 'Shreya', 'Hari', and 'Rohit'. There is no tuple with Name = 'Arun'. Therefore, the subquery produces an empty set $(\emptyset)$.

2. Evaluate the > ALL condition: In SQL, comparison with > ALL (empty set) evaluates to TRUE for every value (vacuously true, because there exists no element in the subquery result that violates the condition).

3. Evaluate the outer query: Since the WHERE clause evaluates to TRUE for every tuple in relation $A$, all tuples of $A$ are returned. Relation $A$ contains $3$ tuples:

   • $(12, \text{Arun}, 60)$

   • $(15, \text{Shreya}, 24)$

   • $(99, \text{Rohit}, 11)$

Thus, the query returns 3 tuples.

Hence, the correct option is (B).