MIS ( Management Info System )

For this assignment, you will be working with the same movie rental database as the ICA #3. The schema is also the same, so you can use the one provided for ICA #3 as a guide. moviedb Schema film actor actor h actor_id film_id last_update actor id first_name last name Last update film film id t 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 staff_id last_update customer customer_id store_id first_name last_name email address_id active create_date last_update Page 1 of 3 Connection Name: Hostname: Username: mis2502 dataanalytics.temple.edu Your username is available on Canvas under Grades>MySQL ID/PW Questions 1. What are the title and rental rate for films rated PG-13 and shorter than 50 minutes? (Hint: R-rated movies have rating value equal to 'R') Display: movie title and rental rate 2. What are the three most popular last names among the actors in the database (Assume no ties)? Display: last name and how many times that name appears in the database 3. What is the average rental rate for each movie rating (i.e., G, PG, PG-13, R, NC-17)? Display: rating and average rental rate rating mention 'action' in their description? 4. How many movies with a Display: number of movies 5. For different film ratings (i.e., G, PG, R, NC-17), which film rating has the lowest average rental rate? (Hint: Get a list of film ratings and the average rental rate of each film rating, arranged in ascending order based on the average rental rate, and returning only the first row. Assume no ties - there's only one film rating with the highest value.) Display: rating and its average rental rate 6. How many customers are named "Paula Bryant"? Display: number of customers 7. Return the first five unique last name of customers which starts with a letter "T" based on alphabetical order. Display: last name