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;