using the sakila databse, answer the following questions 1. Your professor wants you to find all the information related to the films whose rating is NOT R, has “dog” word mentioned in its...

using the sakila databse, answer the following questions

1. Your professor wants you to find all the information related to the films whose
rating is NOT R, has “dog” word mentioned in its description, and language is in
English.

2. Provide your professor the name of the movie titles (along with Inventory ID) which
are currently rented right now (and has not been returned by the customers). Please
keep in mind that, in the rental table, any movie rented out but not returned yet will
have NULL in the return_date attribute.

3. Based on given database, which Rating type (such as R, or PG or others) have the
highest total rental_duration in total (as given in film table).