3.9 LAB - Multiple joins with aggregate (Sakila) 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 ROUND() and AVG() functions.

The query is given in the below step

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

3.9 LAB - Multiple joins with aggregate (Sakila)

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 ROUND() and AVG() functions.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions