Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

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

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

More Books

Students also viewed these Databases questions

Question

Have entry and exit criteria been established?

Answered: 1 week ago

Question

Brief the importance of span of control and its concepts.

Answered: 1 week ago

Question

What is meant by decentralisation?

Answered: 1 week ago

Question

Write down the Limitation of Beer - Lamberts law?

Answered: 1 week ago

Question

Discuss the Hawthorne experiments in detail

Answered: 1 week ago

Question

Explain the characteristics of a good system of control

Answered: 1 week ago