Write the following queries in relational algebra, using the schema provided for the MOVIES database.

ACTOR (actor_id, first_name, last_name, last_update)

LANGUAGE (language_id, name, last_update)

CATEGORY (category_id, name, last_update)

FILM (film_id, title, description, release_year, language_id, length, rating, last_update)

FILM_ACTOR(actor_id, film_id, last_update)

FILM_CATEGORY (film_id, category_id, last_update)

COMMENTS (review_id, film_id, reviewer_name, comment, score, last_update)

Please answer in Relational Algebra NOT MySQL

1. Retrieve the title of all the Movies in the Sports category, rated R and without actors with a last name bigger or equal than TERRY (alphabetically).

2. Find all the movie titles with actors called BILL OR actors called JOSEPH and, at the same time, with comments from 'Mando99'.

3. Find the actors name and last name having movies in all the categories.