$3\mathrm{.}10$ lab multiple joins with aggregate $($sakila$)$

$2433$: Database Development and Management home $>3\mathrm{.}10$ : LAB $-$ Multiple joins with aggregate $($Sakila$)$

LAB

ACTIVITY

$3\mathrm{.}101$: 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. The tables are initialized with LOAD rather than INSERT statements. The LOAD statements read data from.cSv

files. In these files, $\frac{\frac{?}{?}}{?}$ represents nuli.

Write a statement 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 statement should exclude films with no actors and actors that do not appear in films.

Hint: Use the ROUND $()$ and AVG $()$ functions.