Relational Algebra & SQL

1:00

Question 1 of 1

Consider the relations r(A, B) and s(B, C). The SQL query `SELECT A, C FROM r, s WHERE r.B = s.B` is equivalent to which of the following relational algebra expressions? [GATE CS 2001]

Π_{A,C} (r ⋈ s)

Π_{A,C} (σ_{r.B=s.B} (r x s))

Π_A(r) x Π_C(s)

σ_{A,C} (r ⋈ s)