Write a representation of the following in relational algebr

Write a representation of the following in relational algebra.

3. SELECT city, zipcode FROM branches WHERE branch_number IN (SELECT branch_number FROM transactions)

Solution

SELECT city, zipcode FROM branches WHERE branch_number IN (SELECT branch_number FROM transactions)

Relational algebra for above given SQL query------>