I'm working in MySQL and need help with the following questions:

1. Which store (identified by store_id) has the most movies in their inventory? 

2. Which actors with a last name beginning with the letter "J" have starred in movies in the French language?

3. Which are the languages of the movies that Patricia Johnson has rented and how many has she rented in each of those languages?

4. What is the shortest R-rated movie in French and how long is it? 

Use the last page of the attachment for the Schema

 

 

In-Class Exercise: SQL #1Getting Information out of a DatabaseTo do this exercise, you will be working with a movie rental database. The schema for this database isprovided at the end of this document. All of the tables are in a schema called simply “moviedb” (notm0moviedb, m1moviedb, etc.). You can’t write to any of the tables – you can only use SELECTstatements to read from them (so don’t worry about causing any damage).Spend some time looking at the schema carefully. The field names are pretty self-explanatory. Forexample, here are three tables:You can see that a film has a title, description, rating, and length (among other things). You can also seethat an actor has a first name and a last name. The film_actor table implements the many-to-manyrelationship between actor and film (i.e., a film can have more than one actor, and an actor can be inmore than one film). You’ll also notice that data types are listed for each field, but they should be prettyobvious – for example, first_name is a VARCHAR because it is a string value.In MySQL Workbench, open the connection to the class server using your username and password. Clickon the “moviedb” schema and then the tables tab to see the list of tables.