Question: A correctly formed SQL query that answers the specific question asked (no extra rows or columns). Providing the correct answer to the question (the results


|
5. How many PG rating movies mention 'of' in their description? Display: number of movies 6. For different film ratings (i.e., G, PG, R, NC-17), which film rating has the highest average rental rate? Display: highest rating and its average rental rate 7. How many customers using store 1 have first name "Kelly"? (Hint: Customer using store 1 has store_id =1) Display: number of customers 8. Return the first five unique last name of actors which starts with a letter M based on alphabetical order. Display: last name moviedb Schema actor actor id film_actor actor id film_id last_update 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 language language_id name inventory inventory_id film_id store_id last_update last_update C 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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
