$3\mathrm{.}10$ LAB $-$ Multiple joins with aggregate $($Sakila$)$

types but fewer rows. The tables are initialized with LOAD rather than INSERT, statements. The LOAD statements read data from. csy

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

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.

$\backslash$Run

$(3)$ History Tutorial

Initialize.sql $\}\backslash$times$\backslash$mathrm$\{$ Main.sql $\}\backslash$times$\backslash$mathrm$\{$ film$\_$actor.csv $\}\backslash$times$\backslash$mathrm$\{$ film.csv $\}$

$1\}\backslash$mathrm$\{$ SELECT

actor.last$\_$name, actor.first$\_$name,

ROUND$($AVG$($film$.$length$),0)$ AS 'average'

FROM actor

INNER JOIN film$\_$actor ON actor,actor$\_$id $=$ film$\_$actor,actor$\_$id

INNER JOIN film ON film$\_$actor,film$\_$id $=$ film,film$\_$id

GROUP BY actor,actor$\_$id$,$ actor.last$\_$name, actor,first$\_$name

HAVING COUNT$($film$.$film$\_$id$)>0$

ORDER BY average DESC, actor.last$\_$name ASC;

I am still receiving error with code error $1146$ table zybooks.actor doesnt exist $.$ What am i doung wrong with he code?