Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please answer all the questions to get upvote and also will leave a positive review it's SQL 1. What are the title and rental rate
please answer all the questions to get upvote and also will leave a positive review
it's SQL
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 first names among the customers in the database? (Assume no ties) Display: last name and how many times that name appears in the database 3. Display all different ratings of movies in the database. Display: name of the ratings 4. 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 5. How many movies with a Grating mention and 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 are named "Paula Bryant"? Display: number of customers 8. Return the first five unique last name of actors which starts with a letter "T" based on alphabetical order. Display: last nameStep 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