Answered step by step
Verified Expert Solution
Question
1 Approved Answer
film_actor filmactor_id 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_duration rental_rate length replacement_cost rating spcial_features
film_actor filmactor_id 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_duration 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 address address_id address district postal_code phone last_update Questions 3. 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 movie length
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