Exercise 2.1 Write the following queries in MongoDB:

1. Return all the information on all customers.

2. Return the email of all customers.

3. Return the email of the customers of Canadian stores.

4. Return the identifier of all rentals made by customers from Iran, where the amount paid is strictly greater than 10 dollars.

5. Return the first and last names of the actors who played a role in film 213.

Exercise 3.1 Write the following queries in MongoDB:

1. Return the identifier of the films that have “Behind the Scenes” as special features.

2. Return the identifier of the films that have as special features all of the following: “Commentaries” and “Deleted Scenes”.

3. Return the identifier of all the films where BURT POSEY played a role.

4. Return the identifier of the film that has exactly 15 actors.

Exercise 4.1 Write the following queries in MongoDB using the aggregation framework:

1. Return the title of the films rented by TOMMY COLLAZO (can you also express this query with the function find()?)

2. Count the total amount of payments across all rentals.

3. Return the number of actors of each film.

4. Sort the films by the number of actors (decreasing order).

5. Return the average number of actors for each film.

6. Return the identifier of the customer who made the most of rentals.

7. Return the first and last name of the customer who made the most of rentals.

8. Return the country where the customers have rented the most of the films in the category “Music”.

Exercise 5.1 Write the following queries in MongoDB using the aggregation framework:

1. Return the language of the film with title “ACE GOLDFINGER”.

2. Return all the information about the staff member who took care of rental 2.