Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Refer to the film, actor, and film_actor tables of the Sakila database. The tables in this lab have the same columns and data types but
Refer to the film, actor, and film_actor tables of the Sakila database. The tables in this lab have the same columns and data types but fewer rows. Write a query that: - Computes the average length of all films that each actor appears in. - Rounds average length to the nearest minute and renames the result column 'average". - Displays last name, first name, and average, in that order, for each actor. - Sorts the result in descending order by average, then ascending order by last name. The query should exclude films with no actors and actors that do not appear in films. Hint Use the ROUNDO) and AVGO functions
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