Using the knowledge of computational language in python it is possible to write a code that organizes film, actor and film and actor at the same time.
<h3>Writting the code:</h3>
<em>SELECT a.last_name, a.first_name, ROUND(AVG(f.length)) AS 'average' </em>
<em>FROM film f </em>
<em>INNER JOIN film_actor fa ON f.film_id = fa.film_id</em>
<em>INNER JOIN actor a ON a.actor_id = fa.actor_id</em>
<em>GROUP BY a.last_name, a.first_name</em>
<em>ORDER BY average DESC, last_name ASC;</em>
See more about python at brainly.com/question/18502436
#SPJ1