Question: could you please tell me the correct query based on the data, using MySQL workbench? it's saying 6 is incorrect as well. 4. What is



could you please tell me the correct query based on the data, using MySQL workbench? it's saying 6 is incorrect as well.
4. What is the two most popular first names of customers who live in postal code greater than 40000? Display: first name and the number of first names 6. What's the most expensive (in terms of rental rate) film by Penelope Guiness? And what is the rental rate? Display: title and rental rate film film_actor filmactor id actor_id film_id last_update actor actor id first_name last_name last_update film id title description release_year language_id original_language _id rental_duration rental_rate length replacement_cost rating spcial_features last_update language language_id name inventory inventory_id film_id store_id last_update last_update rental address address id address rental_id rental_date inventory_id customer_id return_date staff_id last_update customer customer id store_id first_name last_name email address_id active create_date last_update district postal_code phone last_update What's the most SELECT title, rental. rate, FROM expensive (in terms moviedb.film of rental rate) film JOIN moviedb.film actor by Penelope ON film.filmid= Guiness? And what film actor.film.id is the rental rate? JOIN moviedb.actor ON film actor.actor..id = actor actorid WHERE first name = "Penelope" AND last name = "Gusiness." AND rental rate = (SELECT MAX(rental rate) FROM moviedb.film); 4. What is the two most popular first names of customers who live in postal code greater than 40000? Display: first name and the number of first names 6. What's the most expensive (in terms of rental rate) film by Penelope Guiness? And what is the rental rate? Display: title and rental rate film film_actor filmactor id actor_id film_id last_update actor actor id first_name last_name last_update film id title description release_year language_id original_language _id rental_duration rental_rate length replacement_cost rating spcial_features last_update language language_id name inventory inventory_id film_id store_id last_update last_update rental address address id address rental_id rental_date inventory_id customer_id return_date staff_id last_update customer customer id store_id first_name last_name email address_id active create_date last_update district postal_code phone last_update What's the most SELECT title, rental. rate, FROM expensive (in terms moviedb.film of rental rate) film JOIN moviedb.film actor by Penelope ON film.filmid= Guiness? And what film actor.film.id is the rental rate? JOIN moviedb.actor ON film actor.actor..id = actor actorid WHERE first name = "Penelope" AND last name = "Gusiness." AND rental rate = (SELECT MAX(rental rate) FROM moviedb.film)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
