Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started