Consider the relation schemas:
Rank (name, rank) and student (name, country), where name in student table is a foreign key in table Rank.
Which of the following TRC Queries displays all the student names from India along with their respective ranks?
- $\{ t \mid \exists q \in Rank ( q [name] = t [name] \wedge t [rank] = q [rank] ) \wedge \exists p \in student (q [name] = p [name] \wedge q [country] = " India ") \}$
- $\{ t \mid \exists p \in Rank ( t [name] = p [name] \wedge t [rank] = p [rank] ) \wedge \exists q \in student (p [name] = q [name] \wedge p [country] = " India ") \}$
- $\{ t \mid \exists p \in Rank ( p [name] = t [name] \wedge p [rank] = q [rank] ) \wedge \exists q \in student (q [name] = p [name] \wedge q [country] = " India ") \}$
- $\{ t \mid \exists p \in Rank ( t [name] = p [name] \wedge t [rank] = p [rank] ) \wedge \exists q \in student (q [name] = p [name] \wedge q [country] = " India ")\}$