Relation Algebra Question Write the following Query using re

Relation Algebra Question

Write the following Query using relational Algebra:

Select all distinct members who have published at least one post or who is at least tagged in one post. (Use a set operator)

Solution

select distinct mname from members m JOIN published_posts p where m.mem_email_id = p.mem_email_id JOIN tagged_friends t where p.post_id = t.post_id;