SQL Queries in the relational algebra. list these queries given this schema

List information for films with a rental price over $4. 2

List the titles of films with a rental price over $4.

List outrageously priced films (over $4 or under $1).

List the ID numbers of the films that are expensive and have been reserved. (An expensive film is one that is outrageously priced over $4.)

List the IDs of the expensive films that have not been reserved.

List the titles of all reserved films.

List the customers who have reserved film(s).

List the customers who have reserved expensive films.

List the streets of customers who have reserved foreign films.

List the customers who have reserved all the foreign films.

Find the film(s) with the highest rental price.

------

thank you i will upvote

Customer (CustomerID, Name, Street, City, State, Zipcode) Film (FilmID, Title, RentalPrice, Kind) Reserved (CustomerID, FilmID, ResDate)