1. A correctly formed SQL query that answers the specific question asked (no extra rows or columns).

1. What is the street address of Patricia Johnson?

Display: address

2. Who has starred in movies in the French language? Return only the first five distinct results in alphabetical order by last name. (Hints: (1) Create the query to only return the first five, in alphabetical order by last name; (2) Be sure to reference the language name French in your query. In the language table, there is a field name that contains the film language names.)

Display: first name and last name

3. Who has rented the fewest movies? How many movies did they rent? (Hint: Get a list of all customers and the number of movies they rented, arranged in ascending order and returning only the first row. Assume no ties - theres only one customer with the lowest value.)

Display: first name, last name and number of movies

4. Which are the languages of the movies that Mabel Holland has rented and how many has she rented in each of those languages?

Display: language and number of languages

5. 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. Use a subselect statement with the MIN() function to return only the shortest movie(s). )

Display: movie title and movie length

6. What was the shortest movie starring Daryl Crawford, how long is it, and what was its rating? (Hint: There may be more than one movie returned; Use a subselect statement with the MAX() function to return only the movie with the highest rental rate by Humphrey Willis.)

Display: movie title, length and rental rate

H film filmid title description release_year language_id original_language film_actor filmactor_id actor id film_id last_update actor actor_id first_name last_name last_update _id inventory inventory_id film_id store_id last_update rental_duration rental_rate length replacement_cost rating spcial_features last_update language language_id name last_update address 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 id address district postal_code phone last_update