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

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

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

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!