USE sakila;

SELECT last

$\_$

name, first

$\_$

name, ROUND

$($

AVG

$($

length

$)$

$,$

$0$

$)$

$$AS average

FROM actor

INNER JOIN film

$\_$

actor ON film

$\_$

actor.actor

$\_$

id

$=$

$$actor$.$actor

$\_$

id

INNER JOIN film ON film

$\_$

actor.film

$\_$

id

$=$

$$film$.$film

$\_$

id

WHERE title

$=$

$"$ALONE TRIP"

GROUP BY last

$\_$

name, first

$\_$

name

ORDER BY average;