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

Initialize.sql $\}\backslash$times$\backslash$mathrm$\{$ Main.sql $\}$

actor.first$\_$name,

ROUND$($AVG$($film$.$length$))$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$\_$idHAVING COUNT $(*)>0$

ORDER BY average DESC

actor.last$\_$name ASC;

CONSOLE

ERROR $1064(42000)$ at line $1$: You have an error in your SQL syn

ORDER BY average DESC

actor.last$\_$name ASC' at line $9$