SQL. Please answer all the questions for positive feedback and a thumbs up.

Questions 1. How many times has each inventory been rented? Return the value for all inventories. Display: inventory id and number of rentals 2. What is the street address of Patricia Johnson? Display: address 3. Who has starred in movies in the French language? Return only the first five distinct results in alphabetical order by last name. (Hints: In the language table, there is a field "name" that contains the film language names.) Display: first name and last name 4. How many different districts exist in the address table? Display: number of different districts 5. Who has rented the fewest movies? How many movies did they rent? (Hint: Assume no ties - there's only one customer with the lowest value.) Display: first name, last name and number of movies 6. Which are the languages of the movies that Minnie Romero has rented and how many has she rented in each of those languages? Display: language and number of languages 7. What is (are) the shortest R-rated movie(s) in English? And how long is it are they)? (Hint #1. R-rated movies have rating value equal to 'R'; Hint #2: There may be more than one movie returned.) Display: movie title and movie length 8. What was the shortest movie Daryl Crawford starring, how long is it, and what was its rating? (Hint: There may be more than one movie) Display: movie title, length and rating 9. (Bonus question-optional) What is the average of the average rental rate for each movie rating? (Hint: Find out the average rental rate of each rating and then compute the average of those numbers) Display: average of the average rental rate of rating (The bonus points will be added to your final grade of this assignment. There will be no partial credit for this question.) film_actor filmactor_id actor_id film_id last_update actor actor_id first_name last_name last_update film film_id title description release_year language_id original_language _id rental_duration rental_rate length replacement_cost rating spcial_features last_update inventory inventory_id film_id store_id last_update language language_id name last_update rental rental_id rental_date inventory_id customer_id return_date staff_id last_update customer customer_id store_id first_name last_name email address_id active create_date last_update address address id address district postal_code phone last_update