Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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 name

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

Microsoft Visual Basic 2005 For Windows Mobile Web Office And Database Applications Comprehensive

Authors: Gary B. Shelly, Thomas J. Cashman, Corinne Hoisington

1st Edition

0619254823, 978-0619254827

More Books

Students also viewed these Databases questions

Question

Assess three steps in the selection process.

Answered: 1 week ago

Question

Identify the steps in job analysis.

Answered: 1 week ago