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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started