Customer (CustomerID, Name, Street, City, State, Zipcode)

Film (FilmID, Title, RentalPrice, Kind)

Reserved (CustomerID, FilmID, ResDate)

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

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

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

4. List the ID numbers of the films that are expensive films that have been reserved.

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

6. List the titles of all reserved films.

7. List the customers who have reserved film(s).

8. List the customers who have reserved expensive films.

9. List the streets of customers who have reserved foreign films.

10. List the customers who have reserved all the foreign films.

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