Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. How many times has each language been used in films? Return the value for all six languages. Display: language name and the number of

image text in transcribed
1. How many times has each language been used in films? Return the value for all six languages. Display: language name and the number of films 2. How many actors stared in the film titled "BREAKING HOME"? Display: number of actors 3. Who has rented movies in Japanese 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 last names exist in the customer table? Display: number of unique last names 5. Who has rented the most movies? How many rentals did s/he do? (Hint: Assume no ties - there's only one customer with the highest value.) Display: first name, last name and number of rentals 6. Which are the languages of the movies that Tom Miranda has acted and how many films has he acted in each of those languages? Display: language and number of languages 7. What is (are) the PG-rated movie(s) with the largest replacement cost at store 2? And how much is it (are they)? (Hint \#1. PG-rated movies have rating value equal to "PG'; Hint \#2. Use store_id in the Inventory table; Hint \#3. There may be more than one movie returned.) Display: movie title and replocement cost 8. What is (are) the title(s) and the rental rate of the movie(s) that has (have) the least expensive rental rate among movies acted by Emily Dee? (Hint: There can be more than one movie) Display: movie title, rating, and rental rate 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 per rating (The bonus points will be added to your final grade of this assignment. There will be no partial credit for this question.)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Systems A Practical Approach To Design Implementation And Management

Authors: THOMAS CONNOLLY

6th Edition

9353438918, 978-9353438913

More Books

Students also viewed these Databases questions

Question

5. A review of the key behaviors is included.

Answered: 1 week ago