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. What are the street addresses and phone numbers for California addresses where the

image text in transcribed

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?

Display: address and phone number

2. What are the three most popular first name among the actors in the database? (Assume no ties)

Display: first name and the number of times that first name appears

3. Display all rental rates of movies (without repetition) in the database.

(Hint: Rental rates are stored in rental_rate column in film table)

Display: rental rates

4. You want to find out if movies in different languages command higher rental rate than others. Determine the average rental rate for movies, organized by their language_id. Sort your output so that language_id values are shown in a nice predictable order from lowest to highest.

Display: language id and the average rental rate

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

Secrets Of Analytical Leaders Insights From Information Insiders

Authors: Wayne Eckerson

1st Edition

1935504347, 9781935504344

More Books

Students also viewed these Databases questions