Question: 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

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

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

[Replace this text, including the brackets, with an introduction of the claim and the scenario of this hypothesis test. State your null and alternative hypothesis in sentence format. State your null...

Prepare a Statement of Advice (SOA) for the Martins interviewed for Assignment 1. The case study information is attached as a picture at the bottom of the page. As this assignment is to be a SOA for...

i need help from section 3 part A I have already posted this and you asked me to post under advanced option Assignment Tier 1 Financial Planning (Tier1FPPA_AS_v1A3) Page 2 of 92 Student...

Im having trouble with question 3 part A of the attached file. I know and understand her needs but im not sure if im filling out the table correctly ? Assignment Tier 1 Financial Planning...

CHAPTER 2: RESEARCH METHODS Title: NETFLIX VIETNAM TITLE: THE IMPACT OF NETFLIX ON THE ENTERTAINMENT INDUSTRY IN VIETNAM 2.2.a. Business Environment Analysis by PESTLE The PESTLE analysis will...

Can someone please help me answer the four questions on the first two pages? NA0274 Cavendish Cove Cottages Sean Hennessey, University of Prince Edward Island \"I just don't know if the asking price...

Case Study #4: Ikea in Russia: Emerging Market Strategies and Ethical Dilemmas The Case Study can be found in your textbook. The case is titled Ikea in Russia: Emerging Market Strategies and Ethical...

Students will review examples and evaluate them. Review these documents and evaluate them (click on the link): https://1drv.ms/w/s!AoYu6G3CLyuakjVCGipkRkNSBVUB?e=jrPXX6...

Please provide the answer for the following questions. The questions need good details. Mini Case Number 2 Due in the beginning of March 16th class FIRE ME WHY DON'T YOU? Please read the attached...

2001EHR: Management-Employee Relations Practice-based Assignment Part 1 Reading and Interpreting the Nurses Award Part 2 Employment Relations in Action in Aged Care...

This text was adapted by The Saylor Foundation under a Creative Commons Attribution-NonCommercial-ShareAlike 3.0 License without attribution as requested by the work's original creator or licensee. 1...

Kamila is examining the stock of Wilsonn, Inc., and has been asked to estimate a future price. The firm just paid a dividend of $10.55, which is expected to grow at 0.6%, and Kamila has also...

In C. elegans (worm), dark skin (D) is dominant to colorless (d). Researchers recently discovered a recessive long-lived mutant (g) named granny for the grandmother in the Beverly Hills. A cross...

1 6 . A client in the 3 3 percent marginal tax bracket is comparing a municipal bond that offers a 4 . 5 0 percent yield to maturity and a similar risk corporate bond that offers a 6 . 4 5 percent...