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
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
Get step-by-step solutions from verified subject matter experts
