Question: I need the SQL Query for these, I keep receiving errors. 1. How many PG rating movies mention of in their description? Display: number of

I need the SQL Query for these, I keep receiving errors.

I need the SQL Query for these, I keep receiving errors.

1. How many PG rating movies mention of in their description?

Display: number of movies

2. How many customers using store 1 have first name Kelly? (Hint: Customer using store 1 has store_id =1)

Display: number of customers

3. 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

4. Return the first five unique first name of customers which starts with a letter S based on alphabetical order.

Display: first 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!

Q:

I need the SQL Query for these, I keep receiving errors 1. What are the street addresses and phone numbers for California addresses where the postal code has a numeric value lower than 20000?...

Q:

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...

Q:

For this assignment, you will be working with the same movie rental database as the ICA #3. The schema is also the same, so you can use the one provided for ICA #3 as a guide. moviedb Schema film...

Q:

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 returned from MySQL Workbench). 5. How many...

Q:

title description release_year language_id original_language film actor filmactorid actor id film_id last_update actor actorid first_name last_name last_update _id Inventory Inventory ld film ja...

Q:

Write SQL advance query using joins and subselect that answers each question below using the movie rental database schema provided below Your submission will be graded using two factors: A correctly...

Q:

MIS Management Information System Please answer by filling this table, Thanks! Query Question Answer 1 2 3 4 5 6 7 H film film_id title description release_year language_id original_language...

Q:

Write SQL advance query using joins and subselect that answers each question below using the movie rental database schema provided below Your submission will be graded using two factors: A correctly...

Q:

Management info system (MIS) If you only find the query that's fine I will run it and find the answer. Thanks !! Please answer by filling this table If you only find the query that's fine I will run...

Q:

MIS ( Management Info System ) For this assignment, you will be working with the same movie rental database as the ICA #3. The schema is also the same, so you can use the one provided for ICA #3 as a...

Q:

Looking to partner with another company by letting them use & sell our software platform as a service, white labeled, in exchange for a revenue share. Operating Income $ (835.500) $ (525.000) $...

Q:

(Multiple choice) Use the Buffalo Bell Corporation financial statements that follow to answer questions 1 through 6. 1. Buffalo Bells days sales in average receivables during 2012 was a. 137.9 days....

Q:

A 1 0 % bonds payable is issued when the market interest rate is 1 0 % .

Q:

CT Corp Comprehensive Question Canadian Tire Corporation, Limited ( Canadian Tire ) is a family of companies that includes a retail segment and a financial services division, among others. The retail...

Q:

Do you think it was appropriate on the part of Nitin to enlist the services of a consultant to review the appraisal system? What are the relative merits and demerits of engaging consultants for such...

Q:

Comment on the recommendation of the consultant to replace the present system with 360-degree appraisal. What other degrees (like: 90, 180, 270, 540, and 720 degrees) could be considered in the case...

Q:

Discuss the feasibility and desirability of fixing and periodically reviewing the KPAs for each employee. Would it be better to do this exercise for job-categories rather than for each individual...