Management Information System MIS

1)	Query	Answer
2)
3)
4)
5)

To do this exercise, you will be working with a movie rental database. The schema for this database is provided on the accompanying document. All of the tables are in a schema called simply "moviedb" (not momoviedb, mimoviedb, etc.). You can't write to any of the tables - you can only use SELECT statements 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. For example, here are three tables: moviedb Schema film_actor 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_ducation 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 customer customer_id store_id first_name last name email address_id active create_date last_update staff id last_update You can see that a film has a title, description, rating, and length (among other things). You can also see that an actor has a first name and a last name. The film actor table implements the many-to-many 1. What is the title and length of the longest movie in the database? Assume there could be more than one movie with the longest value and use a subselect with the MAX() function to find the movies with the greatest length. Display: title and length (Hint: You cannot use LIMIT as below as there can be more than one movie with the same longest value SELECT title, length FROM moviedb.film ORDER BY length DESC LIMIT 1;) 2. In which films did Sandra Peck star (only return the first five)? Display: title 3. How many movies has the customer Adam Gooch rented? Display: number of movies (HINT: You need to use the customer table and the rental table.) 4. What's the most expensive (in terms of rental rate) film by Penelope Guiness? And what is the rental rate? 5. How many different ratings are there in Film table? Display: number of different ratings