Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Moviedb Schema actor film_actor country actor id actor id country id first_name K film id country last_name last_update last_update last_update * film city film id

image text in transcribedimage text in transcribed
Moviedb Schema actor film_actor country actor id actor id country id first_name K film id country last_name last_update last_update last_update * film city film id city id language title city language id H K description country_id name release_year last_update last_update language_id rental_rate rental_duration inventory length address inventory id replacement_cost address id film_id Hrating address store_id special_features address2 last_update last_update district city_id rental customer postal_code rental id customer id phone rental_date store_id ocation inventory_id first_name last_update customer_id Hlast_name return_date email staff id address_id last_update active create_date last_update 1. How many movies do not have an inventory? 2. For different film ratings (i.e., G, PG, R, NC-17), which rating has the highest average length? (Assume no ties - there is only one film rating with the highest average length) 3. List all the active customers who lives in CANADA?4. Which customers have the highest number of late records? (Assuming no ties in the fifth place- List top 5 customers with highest number of late records. Late records are defined as number of rentals that are returned late

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

Introduction to Management Science

Authors: Bernard W. Taylor

11th Edition

132751917, 978-0132751919

More Books

Students also viewed these General Management questions